98
15
I have a formula in a cell which counts the values in 2 other cells. Normally, after entering in the values in these 2 other cells, the formula cell updates automatically when Enter is pressed or when the cells are clicked out of.
However, for some reason, the value calculated by the formula does not update automatically. I am having to click on the formula bar, then I have to click enter for the formula cell to do its thing.
Why is this happening?
I have 2007 and somehow this option reverts back to manual. – 3bdalla – 2015-04-25T09:27:49.970
2@3bdalla: Perhaps you have executed a macro that contains the line
Application.Calculation = xlCalculationManual
? – Jean-François Corbett – 2015-09-29T07:09:13.073This seems to be workbook related, so it may need to be adjusted for each workbook. – Sablefoste – 2015-11-23T19:01:57.973
@Sablefoste: No, it isn't. At least not in Excel 2010 and earlier... Haven't tested 2013, but see no reason why this would change. – Jean-François Corbett – 2015-11-23T21:03:31.240
@RFB: Please don't edit other possible answers into this one. Just go ahead and post your own answer. I did it for you this time.
– Jean-François Corbett – 2016-07-04T12:54:40.493In my 20 years plus of using Excel, this is the FIRST time I have come across a sheet that was not set to automatic! – ozzy432836 – 2016-12-09T09:52:14.950