XL2000: Calc Events Are Recalculated When You Open a Worksheet (215703)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q215703

SYMPTOMS

When you open a Microsoft Excel worksheet that contains equations or functions, Excel automatically recalculates the equations and functions. Versions of Excel earlier than Excel 2000 do not recalculate equations automatically when the worksheet opens.

If the worksheet contains an equation with a volatile function, such as the following

=Now()

data can be changed and unintended results can occur.

CAUSE

This behavior can occur when the Calculation option is set to Automatic.

RESOLUTION

To resolve this behavior, follow these steps:
  1. In Excel, on the Tools menu, click Options.
  2. Click the Calculation tab.
  3. Under Calculation, click Manual.
  4. Click to clear the Recalculate before save check box if you want no automatic recalculations at all.

    Note the location of the Calc Now button. Equations are now recalculated only when you force a recalculation by pressing F9 or by clicking Calc Now.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbprb KB215703
©2003 Microsoft Corporation. All rights reserved.