LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating source data links 2a1d Charts and Charting in Excel 0 April 27th 10 02:48 PM
Can't stop Excel 2007 from updating links pe ken Excel Discussion (Misc queries) 1 October 3rd 08 04:36 PM
Updating Links from Closed Source Workbooks Fred Ernst Excel Discussion (Misc queries) 2 January 28th 07 05:14 PM
Stop Excel from updating external links when copying in VBA ExcelMonkey Excel Programming 3 August 7th 05 11:32 PM
Links not updating unless the source is open... John Keith[_2_] Excel Programming 3 March 12th 05 10:29 PM


All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"