Speeding Up Computations
Minimal recalculation, in effect whenever the recalculation mode is set to Automatic and the method is set to Foreground, means that only the cells that are potentially affected by an operation (such as editing a cell, or moving a range of cells) are recalculated. This feature minimizes the work performed during recalculation and thus speeds up your computations.
For more information about different calculation modes and methods, please refer to “Calculations.”