Hi Marshall,

I'm not an expert by i have the same problem ,if you link directly to a cell
it seems to work but if you do 'something' with the link reference, like use
it in a formula it doesn't work. I just programatically open the source
automatically when i open the spreadsheet and close it when i'm done.

Secondly i found two identical spreadsheets from different users, one links,
the other doesn't, don't know why but i remade the one that doesn't work from
scratch ?& now it works.

HTH
Emma

"Marshall Scmidt" wrote:

I have a weird situation in which I have links from one workbook to another
and the destination link does not work unless the source is loaded. I have
linked many workbooks over the years without problems. Am i missing something
simple. If I load the source it works perfectly but its something i don't
want to do.
--
Marshall