Excel is changing my formula for no reason. Can someone explain
Posted by adam on April 18, 2001 12:20 PM
I have two workbooks. One has data and the other links to that data.
On sheet 2 the formulas look like this
=INDEX([Book1.xls]Sheet1!$A$1:$M$10000, MATCH(ramsecname, [Book1.xls]Sheet1!$A$1:$A$10000, FALSE),7)
This is a basic lookup of sheet one's values.
When I delete cells A10:M10000 on sheet 1, the formulas on sheet 2 change to
=INDEX([Book1.xls]Sheet1!$A$1:$M$9, MATCH(ramsecname, [Book1.xls]Sheet1!$A$1:$A$9, FALSE),7)
I dont want this to do this because I rebuild sheet one and I want the links to stay. I cannot CLEAR instead of DELETE because I need all the rows on sheet 1.
Can anyone tell me why Excel changes my formula and how I can keep Excel from doing this ??
Thanks,
Adam