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.
↑ Back to the top
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.
↑ Back to the top
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
↑ Back to the top