Excel not Calculating

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
 
D

Dave Peterson

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

Change it to automatic.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas not calculating - Calculation is on Automatic & I pressed 2
Calculating cells 1
Why does 'calculate' show in the status bar, even after i hit F9? 1
Automatic calculation is not working 4
Sprdsht not calculating 3
Excel Not Responding 1
Excel does not calculate my formulas 13
Formula doesn't work unless hit enter again 5

Top