The information in this article applies to:
SYMPTOMSIn Microsoft Excel version 5.0, a reference to a cell that contains a remote link is not updated if the following conditions are true:
CAUSE
This behavior occurs when you open the linked workbook while the source
workbook is closed. If the cell A1 on Sheet2 in BOOK2.XLS contains an
external link to a value in BOOK1.XLS, and cell A1 on Sheet1 in BOOK2.XLS
contains a link to cell A1 on Sheet1, when you open BOOK2.XLS while
BOOK1.XLS is closed, the value in cell A1 on Sheet1 is not updated.
WORKAROUNDTo update a linked cell that refers to a cell on another worksheet that contains an external link, do either of the following:
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows version 5.0c. REFERENCES
"User's Guide," version 5.0, pages 161-164, 716
links, pasting Additional query words: link
Keywords : xlwin |
Last Reviewed: August 31, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |