View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RiteshB RiteshB is offline
external usenet poster
 
Posts: 1
Default Cell references not working

I have cells refering to other cells in my workbook. But somehow they are not
showing correct values. But if press F2 and then strike enter, the values get
updated. I checked if my formula calcuations were on Manual, but they are
not. I even tried F9, but it also doesnt work.
Now the problem is i dont know for how many of my cells is this problem
occuring? I have about 100 sheets in my workbook.