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

"Dave Peterson" wrote:

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. ...

AndyAnalyst wrote:

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

--

Dave Peterson