Excel formulas not calculating
 

I have several Excel spreadsheets with formulas that won't calc until I
Highlight the cell and hit enter. At the lower left of the spreadsheet I have
the words Ready Calculate but nothing happens. In the past if that would
happen I could hit F9 and the entire spreadsheet would calc but not anymore.
How do I get these back to normal?

Excel formulas not calculating
 

Check this list

http://xldynamic.com/source/xld.xlFAQ0024.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bobber5" wrote in message ...
|I have several Excel spreadsheets with formulas that won't calc until I
| Highlight the cell and hit enter. At the lower left of the spreadsheet I have
| the words Ready Calculate but nothing happens. In the past if that would
| happen I could hit F9 and the entire spreadsheet would calc but not anymore.
| How do I get these back to normal?

Excel formulas not calculating
 

Hi Bobber5
Check in "Tools-Options-Calculation " you maybe set to manual calc.
Regards
Cimjet
"Niek Otten" wrote in message
...
Check this list

http://xldynamic.com/source/xld.xlFAQ0024.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bobber5" wrote in message
...
|I have several Excel spreadsheets with formulas that won't calc until I
| Highlight the cell and hit enter. At the lower left of the spreadsheet I
have
| the words Ready Calculate but nothing happens. In the past if that
would
| happen I could hit F9 and the entire spreadsheet would calc but not
anymore.
| How do I get these back to normal?

Excel formulas not calculating
 

Hi, bobber5-
Sounds like your files require their calculation trees to be re-built.
You can do this by simultaneously pressing CTRL-ALT-SHIFT-F9. The
computer will pause for longer than the usual recalculation. Save the
file afterwards, and all should be back to normal.

Dave O
Eschew obfuscation