ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel wont calculate (https://www.excelbanter.com/excel-discussion-misc-queries/51011-excel-wont-calculate.html)

john mcmichael

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.



Dave Peterson

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


All times are GMT +1. The time now is 08:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com