When automatic calculation is enabled, Excel recalculates the workbook automatically each time a value affecting a formula ...

When automatic calculation is enabled, Excel recalculates the workbook automatically each time a value affecting a formula changes.

If you turn off automatic calculation, you must manually recalculate the workbook, such as by pressing the F9 key or by using the Calculate Now command.