From time to time, and for no apparent reason, the setting for automatic formula calculations is reset.

If you notice that your calculations are not being performed automatically, follow the steps below to update this setting –

1. Select File from the main Excel menu;
2. Select Options from the LHS menu;
3. Then select Formulas; and
4. Check the box alongside Automatic