Explanation

Calculation Options control when Excel recalculates formulas.

Automatic

Excel recalculates formulas automatically whenever relevant data changes.

This is the normal mode for most workbooks.

Manual

Excel waits for a recalculation command instead of recalculating every formula immediately.

Manual calculation can be useful for very large or calculation-heavy workbooks.

Calculation Modes

Excel provides:

  1. Automatic
  2. Automatic Except Data Tables
  3. Manual

Recalculation Commands

You can also use:

  • Calculate Now
  • Calculate Sheet

Example

Suppose:

=B2*C2

If B2 changes from 10 to 20:

Automatic: result updates immediately.

Manual: result may not update until recalculation is performed.

Practice

Create a worksheet with multiple formulas.

  1. Set calculation to Automatic.
  2. Change some input values.
  3. Observe the results.
  4. Change calculation to Manual.
  5. Modify the inputs again.
  6. Recalculate manually.
PreviousNext