Thread: Formula not updating after inserting a row

I have 3 columns C,D and E. The cell in column E takes the value from above that cell in column E and adds to it the values in C and D on the same row and stores the value in E6 =(E5+C6+D6).
This works fine until I insert a row. The formula in column E cell below the insertion does not have its formula updated to reflect the insertion. All other formulas in column E update. I have auto update ticked.

Convert your data to a Table, from Insert Tab. Then you should be able to insert rows and have formulas get included.