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

Links not updating unless the source is open...
 

John

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

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

John Keith wrote:
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?

Links not updating unless the source is open...
 

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

http://www.google.com/groups?selm=sH...wsranger. com

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

John Keith wrote:

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

--

Dave Peterson

Links not updating unless the source is open...
 

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

--
Regards,
Tom Ogilvy

"Dick Kusleika" wrote in message
...
John

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

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

John Keith wrote:
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?