I seem to have a problem with my excel table.
To make it clear, it's a table within the sheet, so not just the normal cells.
After creating a formula in a column (say for example
=A1+A2), this is applied to the entire column. Okay, so far so good.
However I discovered an error in the formula (say
A1 needed to be changed to
C1) and changed the formula accordingly.
Everything seems fine, but when I add rows it autofills the cells of that column with the 'old' formula.
So instead of containing
=C1+A2 the formula
The Excel error message states that the other cells are not the same as the column formula (with the green triangle at the topleft corner).
Any help would be appreciated!