Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel wont calculate
I have an MS Excel spreadsheet that will not calculate. I change numbers and
remove numbers that are in cells used in formulas and the result of the formula doesnt change. I have checked in Tool-options-calculate tab- to make sure that automatic is selected and nothing happens when I press F9. The only odd thing I see is that the shee has the word calculate under the sheet tabs in the lower left of the workbook screen. None of my other workbooks have this. Any help would be greatly appreciated. |
#2
|
|||
|
|||
excel wont calculate
If you have lots and lots of formulas, sometimes the "calculate" doesn't
disappear form the Statusbar. (Excel does finish calculating, though.) http://support.microsoft.com/default.aspx?scid=243495 XL: Calculate Message Remains in Status Bar If 65,536 Formula References john mcmichael wrote: I have an MS Excel spreadsheet that will not calculate. I change numbers and remove numbers that are in cells used in formulas and the result of the formula doesnt change. I have checked in Tool-options-calculate tab- to make sure that automatic is selected and nothing happens when I press F9. The only odd thing I see is that the shee has the word calculate under the sheet tabs in the lower left of the workbook screen. None of my other workbooks have this. Any help would be greatly appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I calculate a MTD total - yesterdays sales in Excel? | Excel Worksheet Functions | |||
How do I calculate the area under a curve in an Excel graph? | New Users to Excel | |||
How do I Calculate a future or past date in Excel? | Excel Discussion (Misc queries) | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions |