Hi,

I have created a worksheet with a column of cells that each have a formula that depends on the value in the cell directly above it. The formula works fine until I add a line between two existing rows. After the line is added, the formula in the cell below where I added the new row is now referencing the cell 2 rows above it, so it has an incorrect value. Excel actually changes the formula in the cell below the new row to reference the old one it was pointing to. I'm using the R1C1 reference style.

I don't have to do my calculations this way , so any help or suggestions would be appreciated.

Thanks,
Tom