Automatic refresh of external data
 

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.

Automatic refresh of external data
 

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

--
Tim Zych
www.higherdata.com
Compare data in workbooks and find differences with Workbook Compare
A free, powerful, flexible Excel utility

"Rick" wrote in message
...
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.