ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   message "Warning: Open source to update values..." (https://www.excelbanter.com/links-linking-excel/16422-message-%22warning-open-source-update-values-%22.html)

rbyteme

message "Warning: Open source to update values..."
 
I get this message when trying to update links in certain files (2002
version)...
Warning: Open source to update values Click Open Source. The link cannot
be updated until the source is open.

Why does this happen and/or is there any way to make it go away? The source
file is valid, the links are correct (and they do in fact update when cell
addresses are changed. Relinking (change source) the file doesn't seem to
make a difference. Links are to network drive.

Not causing any problems, just very annoying. thanks.

Bill Manville

Any chance that the source files were saved with an earlier version of
Excel?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup



All times are GMT +1. The time now is 11:45 PM.

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