Calculate at the bottom of the sheet?

[Guest]

On one of my files at work, the word "Calculate" appears at the bottom of the
page about a 1/3 of the way next to "Ready." It is only on one file. What
does this mean? Is this something that is going to effect how the different
sheets are calculated? Thanks

 

[barrfly]

The autocalculation function has most likely been set to calculat
manually. This is an option that you can change in the tools -
options-> calcualtion tab. If it a large file and takes a long time t
calculate, or if it is your preference to keep in as a manual calc file
simply press the F9 key to manually calculate the workbook, or pres
shift F9 to manually calculate the avtiveworksheet

 

[Dave Peterson]

If excel is set for manual calculation (tools|Options|calculation tab), and
you've made a change to the worksheet, then excel warns you to recalculate
before you trust the displayed values.

But there are some cases when calculate appears even when the calc mode is set
to automatic.

This is from a KB article:

http://support.microsoft.com/default.aspx?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula References

....After the workbook has passed this limit, Excel no longer attempts to
recalculate only changed cells. Instead, it recalculates all cells after each
change. This behavior is by design of Microsoft Excel.

Microsoft Excel will correctly calculate all formulas. ...

 

[Guest]

Thanks Dave, that was exactly what I was looking for.