The information in this article applies to:
SYMPTOMS
If a worksheet contains formulas that refer to global defined names that
are located in another worksheet, the formulas in the worksheet may be
recalculated incorrectly.
CAUSEIf the same named cell is used in formulas on several worksheets, and you then change the value in that named cell, Microsoft Excel queues the references to that cell to recalculate the dependent cells. If one of those sheets also contains intricate formulas referring to other user-defined references, Microsoft Excel will recalculate that entire sheet but may fail to continue recalculating the queued references on the other sheets. RESOLUTIONTo work around this problem, replace the defined names in the formulas with cell references. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem is corrected in Microsoft Excel for Windows, version 5.0c. Additional query words:
Keywords : xlwin |
Last Reviewed: October 6, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |