View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
J@Y J@Y is offline
external usenet poster
 
Posts: 127
Default Cell doesn't update automatically even when Calculations are on Au

This problem happened once. None of my cells which had link reference to
another cell in another worksheet was updating. I had to go in there and
select then enter. I have Calculations in options on automatic. It's weird
because after I select and enter, the cells start updating bythemselves
again. Anyone experienced this or know why it happened?