I am new to excel 2010, I am sure this didnt used to happen in excel 2003 but here is the problem:
I have a formula in say E10 that looks in cell E10 and E11. this works fine.
But if I delete row 11 the formula in E10 does not work anymore. seems to be putting #REF! in the formula in E10 where it references E11.
I want to be able to delete rows but other formulas referencing this row would still work. Row 12 would now be row 11 if 11 deleted.