ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Stop links updating when source is open (https://www.excelbanter.com/excel-programming/438574-stop-links-updating-when-source-open.html)

KB

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