Excel functions not auto updating
A workbook of mine that worked fine for several years, when using Excel 2003, suddenly refused to update all the formulas, after a switch to Excel 2010. When someone tells you that formulas aren’t calculating, it’s probably because the Calculation setting has been changed to Manual, instead of Automatic.
Even more mysterious, the calculations worked fine on some machines, but not others. That can happen if the first workbook that you open in an Excel session was saved as Manual calculation.
However, editing the formula in that column for that row would ordinarily change the calculation for the entire column because, by default, formulas always replicate throughout the entire column in a table.
To make a “one-off” formula in a table, enter the desired formula in the cell of interest and press Enter.
When you do, Excel automatically copies the formula to the remaining rows in the table.
It isn't perfect: you'll still have to adjust the column width and enter a column heading.
Or, go to the Excel Options window, and click Formulas.
They do appear to be just an easy way to apply some fancy formatting to a data range, but tables are far more than that.
Tables have special properties that will make you more productive and efficient.
Enter the following function in cell B7: =SUM(B3: B6).
When you do, Excel displays a dropdown arrow next to the cell. Simply select one of the listed functions to quickly update the current function.