ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   2003 Automatic Query Refresh (https://www.excelbanter.com/setting-up-configuration-excel/76454-2003-automatic-query-refresh.html)

Dean

2003 Automatic Query Refresh
 
I'm using Excel 2003 with Data Queries. Each time I open my spreadsheets
that have data queries set to run automatically I get a box advising me of
the "Query Refresh" and asking me if I want to "Enable Automatic Refresh" or
"Disable Automatic Refresh"!
How can I set this to "Enable" for all spreadsheets as a default?
I've looked in tools/Options but I assume I'm missing it somewhere!

Thanks in advance
Dean


All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com