Auto Refresh on Opening

S

sonya

Created an Excel spreadsheet that runs an Access database
query and loads the results into a cell.

Problem - I want the data automatically refreshed (from
Access)when I activate the spreadsheet in Excel. How/Where
do I "code" for Excel to "refresh" before showing me the
first worksheet. (Don't want to see a prompt - just want
to get the latest data without having to click data
refresh.) Thanks.
 
S

Stephen Bullen

Hi Sonya,
Created an Excel spreadsheet that runs an Access database
query and loads the results into a cell.

Problem - I want the data automatically refreshed (from
Access)when I activate the spreadsheet in Excel. How/Where
do I "code" for Excel to "refresh" before showing me the
first worksheet. (Don't want to see a prompt - just want
to get the latest data without having to click data
refresh.) Thanks.
Click to expand...

Once you've set up the query, right-click in the data range, select
"Data Range properties" and tick "Refresh data on file Open"

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk
 
Top