XL5: Name Value Not Updated If Worksheet Not ActiveLast reviewed: January 3, 1997Article ID: Q111903 |
The information in this article applies to:
SYMPTOMSIn Microsoft Excel, if you use a defined name in a formula on a worksheet, and then change the value of that name when the active sheet is not a worksheet, the value of the defined name is not updated on the worksheet.
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.
WORKAROUNDTo update the value of a defined name in a formula on a worksheet when you change the value of the defined name, do either of the following:
MORE INFORMATIONWhen you define a name on a workbook using the Define Name dialog box or the Names box, the value of any new or changed name on the workbook is updated and the new value appears in any formula in which it is used. However, if you change the value of a defined name on the workbook while a worksheet is not the active sheet, the workbook is not recalculated and the value of a defined name is not updated in any formula in which it appears.
|
KBCategory: kbprb
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |