LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 175
Default Links not updating unless the source is open...

What would cause some links to not-update (with the source closed). I have
numerous links that for the most part all will update with changes, or on
opening. I have one set of links that don't seem to follow the rest. What
would cause this to happen?

The link that is not updating (that is until I open the source workbook) is
using the volitile "indirect" function which I thought always did a
recalcuation, which should have activated the link. The indirect function is
pointing to a cell containing the text of a defined name range which is
pointing to an external workbook.

Is there a way to force excel to go ahead an look into the closed workbook?
or will I have to just always open the external source?

--
Regards,
John
 
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
Updating link to external source without having it open Gunti Excel Discussion (Misc queries) 1 November 13th 08 10:53 AM
Why will links not update unless source is open? WesJFrank Excel Discussion (Misc queries) 4 August 3rd 07 03:14 PM
Updating Links from Closed Source Workbooks Fred Ernst Excel Discussion (Misc queries) 2 January 28th 07 05:14 PM
XL2003 Destination and Source Open but not updating tim Excel Discussion (Misc queries) 2 December 14th 04 01:29 AM


All times are GMT +1. The time now is 06:23 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"