why have my spreadsheets stopped calculating formulas?
 

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.

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


"dfbaskwill" wrote in
message
...
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.

"Chip Pearson" wrote:

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


"dfbaskwill" wrote in
message
...
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.

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

"Chip Pearson" wrote:

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


"dfbaskwill" wrote in
message
...
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.