Links not updating unless the source is open...

[Guest]

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?

 

[Dick Kusleika]

John

While INDIRECT is volatile, it doesn't work on closed workbooks. As far as
I know, there's no way around this limitation.

 

[Dave Peterson]

Harlan Grove wrote a userdefined function called =Pull() that will do what
you want.

http://www.google.com/[email protected]

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Tom Ogilvy]

Just to add, this information is provided in the help text of the Indirect
function.