View Single Post
  #1   Report Post  
TJ
 
Posts: n/a
Default Why do I have to enter the cell (F2) for cell to calculate?

I have an extensive workbook that does not always calculate when I hit F9. I
often have to enter each cell by hitting F2, theb Ctrl+Shft+Entr in order for
cell to calculate. This is very cumbersome when there are thousands of cells
that contain formulas.