Excel 2016 is not updating calculations

26-Apr-2016 20:36

You’ve created the reports for your management meeting, and, just before you print copies for the executives, you discover that the totals are all showing last month’s values. On the Formulas ribbon, look to the far right and click Calculation Options.

To change this, open the workbook, select the "Formula" tab (Alt+M), then click "Calculation Options" and the select "Automatic". I think this can happen when you end up with different data types in the fields in the given range.

Can you check and make sure the data in there is all still numerical?

excel 2016 is not updating calculations-86excel 2016 is not updating calculations-34excel 2016 is not updating calculations-66

The only thing unusual about this file is that it was marked as final, then unmarked as final. Neither F9 nor turning on Iterative Calculation made the cells in question update, but double-clicking the cell and pressing Enter did.Other references are updating fine though, it is just this one [email protected] Williams Both Ctrl-Alt-F9 and Ctrl-Alt-Shift-F9 updated the cells and made it so they are updating correctly. I searched the Excel Help and found this in the help article titled I had a similar issue with a VLOOKUP.Is there some obscure setting that has been triggered in this file that is creating this issue?That is correct, no circular references and circular references are not allowed.I have: I cannot put my cursor in each box and hit enter, there are too many boxes.

The only thing unusual about this file is that it was marked as final, then unmarked as final. Neither F9 nor turning on Iterative Calculation made the cells in question update, but double-clicking the cell and pressing Enter did.Other references are updating fine though, it is just this one [email protected] Williams Both Ctrl-Alt-F9 and Ctrl-Alt-Shift-F9 updated the cells and made it so they are updating correctly. I searched the Excel Help and found this in the help article titled I had a similar issue with a VLOOKUP.Is there some obscure setting that has been triggered in this file that is creating this issue?That is correct, no circular references and circular references are not allowed.I have: I cannot put my cursor in each box and hit enter, there are too many boxes.In addition, this is creating a major error trap in a spreadsheet that needs to be correct.