Auto Refresh on Opening

  • Thread starter Thread starter sonya
  • Start date Start date
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.
 
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
 
Back
Top