#1   Report Post  
john mcmichael
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do I calculate a MTD total - yesterdays sales in Excel? skcaton Excel Worksheet Functions 0 August 11th 05 02:59 PM
How do I calculate the area under a curve in an Excel graph? Suzanne Graham New Users to Excel 2 July 7th 05 01:51 PM
How do I Calculate a future or past date in Excel? MosMash Excel Discussion (Misc queries) 2 July 6th 05 10:15 PM
How to calculate the data in excel 2002 including only the last 9. TylerMaricich Excel Worksheet Functions 6 November 8th 04 07:27 AM


All times are GMT +1. The time now is 04:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"