Correcting Links in Formulas

If a formula refers to data area range (including relational one):

Cause

On calculating the data area, rows are inserted below the range, which was positioned earlier.

Solution

Use totals mechanism instead of the formulas that refer to data area range.

Detailed description is given in the sections:

See also:

Using Formulas