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

John

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

--
**** Kusleika
Excel MVP
Daily Dose of Excel
www.*****-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?

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

http://www.google.com/groups?selm=sH...newsranger.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

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

--
Regards,
Tom Ogilvy

"**** Kusleika" <[email protected]> wrote in message
news:[email protected]...
> John
>
> While INDIRECT is volatile, it doesn't work on closed workbooks. As far
as
> I know, there's no way around this limitation.
>
> --
> **** Kusleika
> Excel MVP
> Daily Dose of Excel
> www.*****-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?
>
>