Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh External Data code
Every time I open a file that brings external data, it gives me a pop-up
message asking if I want to enable or disable refresh. I need have some code that once the file opens, refreshes the external data (enabled) and keep going without stopping. Any ideas? Thanks. Tony. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh External Data code
Tony7659 wrote:
Every time I open a file that brings external data, it gives me a pop-up message asking if I want to enable or disable refresh. I need have some code that once the file opens, refreshes the external data (enabled) and keep going without stopping. Any ideas? Thanks. Tony. I would say... Try using the Link manager to tell the workbook to always refresh linked data without prompting. In Excel 2003 this is done in Edit | Links... | Startup Prompt... This property can also be set in code: ActiveWorkbook.UpdateLinks = xlUpdateLinksAlways But then again... This doesn't always work for me. In some workbooks where I have set "no alert, update links", I get prompted anyway. It's as though sometimes the setting is completely ignored. I always have macro security on "low" FWIW. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External data refresh | Excel Discussion (Misc queries) | |||
Refresh external data | Excel Programming | |||
external data refresh | Excel Discussion (Misc queries) | |||
Automatic refresh of external data | Links and Linking in Excel | |||
Run Macro on External Data Refresh | Excel Programming |