why have my spreadsheets stopped calculating formulas?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


message
news:D[email protected]...
 
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...
 
Thank you, I've been going crazy with this. I think Options was the only
thing I didn't try.
 
You must log in or register to reply here.

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

Vlookup not calculating 3
formulas not auto calculating and will not calculate 8
using formulas from other workbooks 2
Backwards Compatibility with Excel 2002 2
Dependent "If" formulas 2
Recalculation does not work 8
Display message while calculating forumlas 3
Sheet Names and Auto-calculation 2

Back
Top