My one workbook will only update corectly if the original workbook it's
linked to is already open. When I open and "update values", if that original
book isn't already open, all my values come back as #VALUE errors. What's the
deal? I have bunches of other worbooks linked to each other, and they don't
do this, they all update each other fine.
adey v.

Has the location of either the source or target file _changed_ since the
links were created?

Regards |:)

"adey v." wrote:

My one workbook will only update corectly if the original workbook it's
linked to is already open. When I open and "update values", if that original
book isn't already open, all my values come back as #VALUE errors. What's the
deal? I have bunches of other worbooks linked to each other, and they don't
do this, they all update each other fine.
adey v.

Nope. And that's what seems so strange to me. I have them "living" side by
side in the same folder, right on my desk top. Any ideas?

"CyberTaz" wrote:

Has the location of either the source or target file _changed_ since the
links were created?

Regards |:)

"adey v." wrote:

My one workbook will only update corectly if the original workbook it's
linked to is already open. When I open and "update values", if that original
book isn't already open, all my values come back as #VALUE errors. What's the
deal? I have bunches of other worbooks linked to each other, and they don't
do this, they all update each other fine.
adey v.