View Single Post
  #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