fixing or freezing cell links

C

clovis

I have a multi-sheet workbook in which forumlas in one sheet link to cells on subsequent sheets. When I insert a column in one of the referred to sheets the forumlas automatically change to the "new" location (e.g. C25 become D25). Is there a way to prevent the forumlas from changing as I insert columns?
 
F

Frank Kabel

Hi
try
=INDIRECT("'sheet1'!C25")
-----Original Message-----
I have a multi-sheet workbook in which forumlas in one
Click to expand...
sheet link to cells on subsequent sheets. When I insert a
column in one of the referred to sheets the forumlas
automatically change to the "new" location (e.g. C25
become D25). Is there a way to prevent the forumlas from
changing as I insert columns?
 
Top