Excel 2016 formulas not updating
You must remember to switch the calculation mode back to Automatic. Choose Options under Help, and then choose Formulas in the left pane.
Make sure Automatic is selected in the Calculation Options section, unless of course, you have a specific reason for using manual (which is possible, but unusual).
Dogknees was the first to mention that the calculation method might be set to Manual - and that is the problem, but as bill.kuunders mentioned, it gets worse.
This isn't a case of the calculation switch being flipped for a single workbook.
One thing I have noticed is that when I want to drag a value down a number of rows within a formatted table excel 2016 takes a very, very long time to complete.We customize your e Book by discreetly watermarking it with your name, making it uniquely yours.Book Content Update Program Master core Excel 2016 tools for building powerful, reliable spreadsheets with Excel 2016 Formulas and Functions.I work with about 60 excel documents on a monthly basis, each with 3-4 tabs which have been affected, which I think should give you an idea of how ridiculous this is.
Basically it's telling me that I'm going to have to waste about 30-40 hours of my time to sort this stuff out; correcting the width of rows, making all of the text fit into cells again, and recreating graphs.I am using Excel 2016 and having trouble with formula references.