Automatic Query Refresh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Disable alerts
This may be what you want
Search for disable alerts in your forum
 
Dave,

Thanks but I'm still none the wiser. I've searched a couple of the forums
here and even looked on your site!
Can't find "Disable alerts", i've even looked in the help which searches
online.

Can you help a bit further?
Dean
 
Dave,

You have restored my faith in you Excel Gurussssssss. Brill.

Thanks
Dean
 
You must log in or register to reply here.

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 Webquery Refresh 1
Import External Data 1
Stopping "Query Refresh" messages 2
Refreshing formulas automatically 3
How to enable query refresh? 3
enable automatic refresh 4
MS Query - 2 Parameters 2
External Data Refresh all just for one worksheet 3

Back
Top