Text Box Linked to External Workbook May Not Update (173248)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Excel 98 Macintosh Edition
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for the Macintosh 5.0
- Microsoft Excel for the Macintosh 5.0a
- Microsoft Excel for the Power Macintosh 5.0
- Microsoft Excel for the Power Macintosh 5.0a
This article was previously published under Q173248 SYMPTOMS
When you open a workbook that contains a text box, the text box may not be
updated correctly if it is linked to an external workbook.
CAUSE
This problem may occur when the external workbook to which the text box is
linked 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 not
open.
RESOLUTION
Open the external workbook. The text box that is linked to that workbook
will be updated correctly. After this occurs, you can close the external
workbook.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. This problem no longer occurs in
Microsoft Excel 2000.
MORE INFORMATION
When you open a workbook, Excel updates any formulas that refer to
external workbooks, even if the external workbooks are not currently open.
For example, if a formula in Book1 refers to [Book2]Sheet1!$A$1, when you
open Book1, the formula returns the value currently stored in
[Book2]Sheet1!$A$1.
However, Excel does not automatically update any text boxes that refer to
external workbooks, unless the external workbook is also open.
| Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
|---|
| Keywords: | kbbug KB173248 |
|---|
|