View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KB KB is offline
external usenet poster
 
Posts: 41
Default 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