Excel not Calculating

  • Thread starter Thread starter I Maycotte
  • Start date Start date
I

I Maycotte

I don't know why excel will not calculate even when I press F9 (fo
manual calculation). I have to end up going to the formula bar
clicking inside it and pressing enter for it to calculate. Doe
anybody have a reasoning and/or a way to fix this? Thanks.

-- Isaa
 
Do you have calculation set for manual?
tools|option|calculation tab

Change it to automatic.
 
Maybe your data is not numeric?

Re-format all to General then copy an empty cell.

Select the range of data and Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP
 
Back
Top