Microsoft KB Archive/28573

{| = Excel: Automatic Versus Manual Recalculation =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q28573

SUMMARY
In Excel 3.00 both Manual and Automatic recalculations of a worksheet performs an &quot;intelligent recalculation.&quot; This means that when you change a value in a worksheet, Excel knows which formulas need to be recalculated and recalculates only those formulas.

In Excel 2.20 when Calculation is set to Automatic an &quot;intelligent recalculation&quot; is done. However when a manual recalculation is performed, Excel recalculates the entire document.

For more information on calculation, see Pages 285-292 of the &quot;Microsoft Excel User's Guide&quot; version 3.00 manual or Pages 31-36 of the &quot;Microsoft Excel Reference&quot; version 2.2 manual.
 * }