![]() |
Stop links updating when source is open
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 |
All times are GMT +1. The time now is 12:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com