ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   My links won't update! (https://www.excelbanter.com/excel-discussion-misc-queries/54765-my-links-wont-update.html)

adey v.

My links won't update!
 
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.

CyberTaz

My links won't update!
 
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.


adey v.

My links won't update!
 
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.



All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com