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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521657

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" wrote:


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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521657

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521657

Dave,

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

Thanks
Dean

"davesexcel" wrote:


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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521657