2016 excel formula not updating
This is difficult to notice so can go unrecognised, however it will prevent the formula from calculating. When an apostrophe (‘) is entered before typing in Excel, that tells Excel to store the content as text.
Your formulas are the driving force for your spreadsheet.
Choosing any format other than General will prevent Excel from changing the format.
Look at the bottom of the Excel window for the words CIRCULAR REFERENCES.
Correct the circular reference and recalculate your spreadsheet.
You can fix most recalculation problems with one of these three solutions.