Excel 2016 formulas not updating
In this image, you can see that the calculation options is “Automatic”. If there is certain functions and the calculation options is “Automatic”, whenever you open the file, those functions will recalculate automatically and produce new results.On the other hand, if this is a macro workbook, certain codes will also have the same effect.This is a very important point that you need to be careful.
To make the data more accurate in the workbook, you need to change in Excel options.
Sometimes you will see the information that asks you whether you want to save the changes or not. It is indeed a very good feature that can avoid data loss to certain degree.
If you make some modifications to an Excel file and then close it without saving, it will ask you whether you want to save the changes.
If you have formulas, pressing F9 should recalculate the sheet and update the number format.
But in my experience, I haven’t had this problem with formulas.