Microsoft KB Archive/215544

= XL2000: CELL Worksheet Function Is Not Updated Automatically As Expected =

Article ID: 215544

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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.

Additional query words: XL2000

Keywords: kbbug kbpending KB215544

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.