Auto Refresh on Opening

[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.

 

[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.

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