Automatic Query Refresh

[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

 

[davesexcel]

Disable alerts
This may be what you want
Search for disable alerts in your forum

 

[Guest]

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

 

[davesexcel]

http://support.microsoft.com/default.aspx/kb/248204?
Maybe this will help

 

[Guest]

Dave,

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

Thanks
Dean