Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I need some help:
I have a data source file which is overwritten regularly and a report file that contains links to the data file. I would like to ensure that the links do not refresh if the report file is opened when the source file is also open. I have set the startup prompt to don't update automatic links (although the automatic radio button is still highlighted) and have tried ensuring that the data file is closed as a first action under the Workboo_Open sub however neither of these seem to work. I have searched the internet and can't find a solution so any ideas would be welcome Thanks KB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Updating source data links | Charts and Charting in Excel | |||
Can't stop Excel 2007 from updating links | Excel Discussion (Misc queries) | |||
Updating Links from Closed Source Workbooks | Excel Discussion (Misc queries) | |||
Stop Excel from updating external links when copying in VBA | Excel Programming | |||
Links not updating unless the source is open... | Excel Programming |