Greetings,

I have some cell formulae on sheet2 refering to cells on sheet1. I
want the formulae on sheet2 to _never_ change, no matter what happens
on sheet1.

I am finding that when I "move" cells on sheet1, the references on
sheet2 reflect that move ... with both relative and absolute
designations. I also tried locking sheet2 to no avail.

For example: I want "=sheet1!A1" to always point to top left cell of
sheet1, no matter what happens to the cells of sheet1.

So, how can I keep the formulae from changing???

Thanks in advance,
WD


--
William DeLeo
------------------------------------------------------------------------
William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256
View this thread: http://www.excelforum.com/showthread...hreadid=518274