Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 03 Stopped Calculating Formulas | Excel Discussion (Misc queries) | |||
MICROSOFT EXCEL NO LONGER CALCULATING FORMULAS | Excel Discussion (Misc queries) | |||
Excel not calculating formulas | Excel Worksheet Functions | |||
calculating formulas in excel | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) |