"Calculate" appears in staus bar

[Tonso]

In Excel 2003, what does it mean when "Calculate" appears in the left
side of the staus bar. I checked options, and calculate is set to
automatic. In most instances, calcuations are automatic. but i have
lately had one workbook that switches to manual calculate. But not
always. I did open a file that was created in XL2010. But it had no
macros. When I see "Calculate" in the status bar, what does it mean?

Thanks,

Tonso

 

[Clif McIrvin]

In Excel 2003, what does it mean when "Calculate" appears in the left
side of the staus bar. I checked options, and calculate is set to
automatic. In most instances, calcuations are automatic. but i have
lately had one workbook that switches to manual calculate. But not
always. I did open a file that was created in XL2010. But it had no
macros. When I see "Calculate" in the status bar, what does it mean?

Thanks,

Tonso

In xl2010 it means that the worksheet / workbook has not been
calculated, and xl thinks that it might need to be re-calculated. You
can press<F9> -or- click on the word Calculate in the status bar to do a
manual calculation.

If a workbook gets set to manual calculation and saved it will always be
manual calculate (until you change it back to automatic and save it),
even if you have xl set to automatic calculation.

It is also possible for a macro to change calculation from automatic to
manual.

 

[Stan Brown]

In xl2010 it means that the worksheet / workbook has not been
calculated, and xl thinks that it might need to be re-calculated. You
can press<F9> -or- click on the word Calculate in the status bar to do a
manual calculation.

I thought that too, but today I got a workbook from a customer that
displayed "Calculate". I pressed F9 and "Calculate" remained.

I suspect the issue may be circular references, but I got diverted
into other things and didn't have time to check.