Excel formulas not calculating

  • Thread starter Thread starter bobber5
  • Start date Start date
B

bobber5

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?
 
Check this list

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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?
 
Hi Bobber5
Check in "Tools-Options-Calculation " you maybe set to manual calc.
Regards
Cimjet
 
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
 
Back
Top