Text Box Linked to External Workbook May Not Update

This article was previously published under Q173248
This article has been archived. It is offered "as is" and will no longer be updated.
When you open a workbook that contains a text box, the text box may not beupdated correctly if it is linked to an external workbook.
This problem may occur when the external workbook to which the text box islinked is not open.

For example, if Book1 contains a text box that is linked to[Book2]Sheet1!$A$1, the text box is not updated correctly if Book2 is notopen.
Open the external workbook. The text box that is linked to that workbookwill be updated correctly. After this occurs, you can close the externalworkbook.
Microsoft has confirmed this to be a problem in the Microsoft productslisted at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.
When you open a workbook, Excel updates any formulas that refer toexternal workbooks, even if the external workbooks are not currently open.

For example, if a formula in Book1 refers to [Book2]Sheet1!$A$1, when youopen Book1, the formula returns the value currently stored in[Book2]Sheet1!$A$1.

However, Excel does not automatically update any text boxes that refer toexternal workbooks, unless the external workbook is also open.
XL98 XL97 XL7 XL5 MXL5 textbox XL

Article ID: 173248 - Last Review: 10/07/2013 06:11:26 - Revision: 1.3

  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 98 for Macintosh
  • Microsoft Excel 95a
  • Microsoft Excel 5.0c
  • Microsoft Excel 5.0 for Macintosh
  • Microsoft Excel 5.0a for Macintosh
  • Microsoft Excel 5.0 for Macintosh
  • Microsoft Excel 5.0a for Macintosh
  • kbnosurvey kbarchive kbbug KB173248