Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic refresh of external data
I posted this is the normal excel group with no response, so here we go.
I've looked and played with all the settings that I think would allow automatic refresh of external data, but I still get a dialog box every time I open the workbook that asks if I really want to enable or disable automatic refresh. Yes I really do! Where is the switch or property which automatically enables this? TIA Keith PS In excel XP (aka 2001?), I get a button to always refresh. In excel 2003, that button and message have been cleared from the dialog box. |
#2
|
|||
|
|||
You need to set a registry key.
Usual caveats about editing the registry apply. In: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel Edit / New / DWord value : name it QuerySecurity Edit / Modify : give it value 2 For more info (relating to Excel 2000) see http://support.microsoft.com/default...b;en-us;248204 Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
Thank You very much!
Keith "Bill Manville" wrote in message ... You need to set a registry key. Usual caveats about editing the registry apply. In: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel Edit / New / DWord value : name it QuerySecurity Edit / Modify : give it value 2 For more info (relating to Excel 2000) see http://support.microsoft.com/default...b;en-us;248204 Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompting to allow External Query Data Refresh | Excel Discussion (Misc queries) | |||
Glue/Lock cells to external data before refresh | Excel Discussion (Misc queries) | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
How can I check if data in an external data range is changed afte. | Excel Worksheet Functions |