The easiest way to see if your template is set to Automatic is to check the grey bar at the bottom of the Excel window when entering data. As you input data you will see the word ‘Calculate’ at the bottom left if Excel is set to Manual and you will then need to reset the setting.
Resetting the Calculation status can be done as follows:
Excel 2010 onwards:
- Open your file in Excel
- Click the Formulas tab at the top of the window
3. Click Calculation Options towards the right of the navigation ribbon.
4. Three options are presented Automatic, Automatic Except for Data Tables, and Manual. If any option is ticked other than Automatic, please click Automatic.
If you save a template for repeated use, please be aware that opening the template whilst your local Excel setting is anything other than Automatic will result in the local setting being applied to the template. You will need to reset the Calculation Options before submitting.