If a formula refers to data area range (including relational):
On extending the data area range, formula range is not extended, and links are not corrected in the formula.
On reducing the data area range, formula range is reduced, and links are corrected.
On calculating the data area, rows are inserted below the range, which was positioned earlier.
Use totals mechanism instead of the formulas that refer to data area range.
Detailed description is given in the sections:
See also: