Relative formula not updating properly

Hello All!

I've just updated to Excel 2016, and found that my relative formulas aren't working properly any more. Has anything changed in 2016 that would cause this?

I have a simple running balance formula that takes the balance from the cell above (Col E), adds income on the same line (Col C), and subtracts the expense from the same line (Col D).

So, with the starting balance in E2, E3=E2+C3-D3

It copied down with no problem, advancing the line number in each row. However, when I delete a row, the formula is not fully corrected. For example, if I delete row 10, the new E10 (which was E11=E10+C11-D11) is now E10=#REF!+C10-D10 when it should be C9+C10-D10.

Any ideas why this would happen? Am I doing something wrong?

Thanks!

I thought it would be clear that all rows below the deleted one would simply have the row numbers in all cell references reduced by one. I'm shocked that in at least 15 years of using Excel I haven't run into this situation before.

Thanks for the solution--it worked great!