Formulas not calculating when values are entered.

T

Todd Blake

I have a spreadsheet that is fairly large with lots of internal linking and
simple adding and subtracting formulas. I encountered an excel error message
stating that excel had to close and would I like a new version saved to keep
the work I had done. So, I did and saved it and was able to reopen the
spreadsheet fine, but now when I enter a value the formulas are not
calculating unless I double click the cell containing the formula, then it
calculates. I also found that the cell will calculate if I hit save? Has
anyone experienced this and have a fix for it?
 
G

garfield-n-odie [MVP]

In Excel 2007, click on Office Button | Excel Options | Formulas
| click the "Automatic" radio button | OK.

In Excel 2003 or earlier, click on Tools | Options | Calculation
tab | click the "Automatic" radio button | OK.
 

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

Need Help with Macro Security 1
My excel spreadsheet won't calculate formulas anymore. Help 2
Set as Default Template not working 0
Excel does not accept text format! 0
Calculation Time 2
formulas not calculating 1
formulas not auto calculating and will not calculate 8
Formulas aren't calculating 2

Top