2003 Automatic Query Refresh

D

Dean

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic Query Refresh 4
query to external data 3
How can I 'Enable Automatic Refresh' for Query Refresh by default 0
Enable automatic refresh 0
help on "ENABLE AUTOMATIC REFRESH".. 0
enable automatic refresh 0
Help, Query Refresh windowm appearing.... 2
Enable automatic refresh 0

Top