Thread: formula locked
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
chum
 
Posts: n/a
Default formula locked


Hello,

I did not put any $ sign, usually when I scroll down excel updates
automatically the calculation ;
if I click again in one of the cell, I can see that the formula has
been updated, but the result's calculation is the same as the 1st one,
and to get the correct I have to click enter in each cell, weird isn't
it ?

thanks


--
chum
------------------------------------------------------------------------
chum's Profile: http://www.excelforum.com/member.php...o&userid=34262
View this thread: http://www.excelforum.com/showthread...hreadid=540975