REF error message when inserting new rows

E

Ellen Dan

A formula that is referencing the cell above returns a REF error message if a new row is inserted between the two. Is there a way to eliminate this problem without having to re-autofill?

I've tested this in both 2000 and also 2002
 
Top