Make sure autocalculate is on A1 3 A2 4 A3 5 A4 =sum(A1:A4) A4 is 12 Delete A2 A4 changes to 8 Press CTRL-Z A4 does not change - it should change to 12
*** This bug has been marked as a duplicate of bug 80846 ***