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.
Author
Josue Nolasco
I'm a former US Marine infantryman who made a switch to IT to provide cyber security services to SMB's. I'm as much a child of technology as I am of the great outdoors. I like spending time playing, experimenting with, and learning new technologies and whenever possible taking camping trips with friends and family.