Excel is Not Updating Calculations
If you have a Microsoft Excel file with calculations and you find Excel is not updating calculations try this quick fix.
Make sure Auto Excel Update is set under the formulas section of your options menu.
First, go to File and select options. Then under the Formulas section check Auto-update. If you have the 2016 version check Automatic under the Calculation options.
Second, click Ok to save the options and you will probably have to restart Excel to see the results.
Third, if you find this doesn’t fix your problem. Our next solution is to try repairing Excel from the control panel. This usually fixes many issues with Microsoft Office applications that may have become corrupted. Take a look at the Excel picture to do the quick repair.