Formula cells not updating in excel
This can be done using Excel's Text To Columns tool as follows: When activated, this option displays all formulas in the current Worksheet.
The option is located in the options panel, under 'Advanced' options.
=IF(B7=””,0, SUMIF(, E7,$D:$D)) Miraculously, that solved the problem!
I held my breath, while we tested on a few more machines, and everything calculated as it was supposed to.
This could have occurred because either: This formatting will cause Excel to interpret anything that is subsequently entered into the cell (including formulas) as text.
Of course, this solution could stop working again, at the next lunar eclipse!
=IF(B7=””,0, SUMIF(, E7,$D:$D)) There was no obvious reason why that wouldn’t work in Excel 2010, but I was getting desperate.
So, I changed the named range to a worksheet reference, using cells on the same worksheet.
We tried using the Calculation shortcuts, including Ctrl Alt Shift F9 (that one recalculates everything, and starts your car).
However, none of the shortcuts had any effect on the non-calculating cells in this workbook.