why have my spreadsheets stopped calculating formulas?

D

dfbaskwill

The sheet calculates only those cells that I retype the formula for. If I
change the values again it will not recalculate until I retype the formula
again.
 
C

Chip Pearson

Most likely, the calculation mode has been set to manual instead
of automatic. Go to the Tools menu, choose Options, then the
Calculation tab. There, check the Automatic check box.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:D[email protected]...
 
D

dfbaskwill

Chip Pearson said:
Most likely, the calculation mode has been set to manual instead
of automatic. Go to the Tools menu, choose Options, then the
Calculation tab. There, check the Automatic check box.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
Click to expand...
 
D

dfbaskwill

Thank you, I've been going crazy with this. I think Options was the only
thing I didn't try.
 
Top