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 |
Automatic Query Refresh
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 |
Automatic Query Refresh
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 |
Automatic Query Refresh
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 |
Automatic Query Refresh
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 |
All times are GMT +1. The time now is 11:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com