Excel is not updating calculations

Excel options

If you have a Microsoft Excel file with calculations and you find Excel is not updating calculations try this fix.

Make sure Auto Update is set under the formulas section of your options menu.

Go to File and select options. Under the Formulas section check Auto-update or in 2016 version check Automatic under the Calculation options.

Click Ok to save the options and you may need to restart Excel to see the results.

If you find this doesn’t fix your problem try repairing Excel from the control panel. This usually fixes many issues with Microsoft Office applications that may have become corrupted. Here’s how to do the quick repair.