I was working with a spreadsheet when I noticed a small issue.

I have some numbers in row 1, 2 and 3 and a function in row 4 (=SUM(A1:A3))

Now when I delete row 3 I expect the function to update to =SUM(A1:A2), instead it is unchanged (just moved up to row 3) and gives a #CIRCULARREF! error.

Regards,

Rob