Automatic refresh of external data

[Rick]

Hi,

I've made several excel templates with information directly linked to an
access database query.

When I open the excel template, I need to confirm "Enable Automatic Refresh"
(unfortunately each independent template)

Is there a possibility to "Automatic" Automatic refresh data.

If any solution, please let me know.

Many thanks.

 

[Tim Zych]

This may help. It involves changing a registry key.

You are prompted to enable automatic refresh when you open a workbook in
Excel
http://support.microsoft.com/kb/248204/en-us