XL2000: CELL() Worksheet Function Is Not Updated Automatically As Expected (215544)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q215544

SYMPTOMS

In Microsoft Excel 2000, when you use the Cell() worksheet function in an equation, the result of the equation may not be updated automatically when a variable is changed.

When you force the equation to recalculate (by pressing F9, for example), the result is changed as expected.

In versions of Excel earlier than Excel 97, the results of an equation containing the Cell() worksheet function are changed automatically.

WORKAROUND

To work around this issue, press F9 to force Excel to recalculate an equation each time that you want to view the most current results of an equation.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbpending KB215544
©2003 Microsoft Corporation. All rights reserved.