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

"Tonso" <(E-Mail Removed)> wrote in message
news:075fbbe4-d91e-405f-a4d4-(E-Mail Removed)...
> 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.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)

On Fri, 2 Sep 2011 07:26:20 -0500, Clif McIrvin wrote:
> 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.



--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...