View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Changed referenced cell between sheets

Niko,

what exactly do you mean? Tell us the formula in C24 and what do you
mean by the referenced cell pointing to another cell.

From the little I understood from your words, this is a behavior that

can come about if a cell is deleted. E.g. If I have a formula =C18 and
then one of the cells above is deleted, C18 moves up and now becomes
C17. The formula will also change and will show =C17. Is this your
case? Then I am not sure you can do much about it. Maybe though the
layout is such that something can be fixed. At any rate, you have to be
more specific.

HTH
Kostis Vezerides