Automatic updating of formulas in excel
The benefit to using cell numbers and letters over actual values is that the formulas that you have created will update their values if you edit a cell value.
This is extremely helpful and can aid you when you have large spreadsheets with entries that are frequently updated.
By default, Excel will adjust the formula result display if a cell that is part of the formula changes.
This is fine for small spreadsheets, or less involved formulas, that don’t require a lot of computing power.
I have a simple cell reference in one of my cells down a column e.g.:"=H6", “=H7” etc.
I do not want to convert the data to a table, since it messes up the filters and formatting.
Unfortunately, if your spreadsheet is very large and contains a high number of formulas, then updating all of your formula values can be a pretty time-consuming and resource-intensive activity.
Fortunately you can make Excel 2010 stop updating your formula totals whenever you make a change to a cell and instead execute all of your formula calculations manually.
Macros don't solve the problem either - they don't copy to the row following the blank one.
To use formulas efficiently, there are three important considerations that you need to understand: Calculation is the process of computing formulas and then displaying the results as values in the cells that contain the formulas.