calculate remains in status bar

[Werner Rohrmoser]

Hi,

Environment: XL2002, WIN XP

Action: Copy some sheets from a source book into a new book,
for distribution purpose (with VBA or manually, it doesn't matter)

Problem: After the procedure is done, the "Calculate" remains in statusbar,
even when I close the source book and the copy book and no book is active.

What's the reason for that behaviour?

Thanks for your support.
Werner

[widemonk]

Has it for some reason turn off automatic calculation? (tools > options > calculation)

Maybe you need to include:-
Application.Calculation = xlAutomatic

[Tushar Mehta]

Check Tools | Options... | Calculation tab. Either Calculation mode is
Manual or Iteration is enabled.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <661bf8a.0504080443.5718233@posting.google.com>, werner-
rohrmoser@hotmail.de says...
> Hi,
>
> Environment: XL2002, WIN XP
>
> Action: Copy some sheets from a source book into a new book,
> for distribution purpose (with VBA or manually, it doesn't matter)
>
> Problem: After the procedure is done, the "Calculate" remains in statusbar,
> even when I close the source book and the copy book and no book is active.
>
> What's the reason for that behaviour?
>
> Thanks for your support.
> Werner
>

[Tom Ogilvy]

http://support.microsoft.com/?kbid=243495
The Calculate message may remain in the status bar when you enter formulas
that include cell references


--
Regards,
Tom Ogilvy


"Werner Rohrmoser" <werner-rohrmoser@hotmail.de> wrote in message
news:661bf8a.0504080443.5718233@posting.google.com...
> Hi,
>
> Environment: XL2002, WIN XP
>
> Action: Copy some sheets from a source book into a new book,
> for distribution purpose (with VBA or manually, it doesn't matter)
>
> Problem: After the procedure is done, the "Calculate" remains in
statusbar,
> even when I close the source book and the copy book and no book is active.
>
> What's the reason for that behaviour?
>
> Thanks for your support.
> Werner

[Werner Rohrmoser]

werner-rohrmoser@hotmail.de (Werner Rohrmoser) wrote in message news:<661bf8a.0504080443.5718233@posting.google.com>...
> Hi,
>
> Environment: XL2002, WIN XP
>
> Action: Copy some sheets from a source book into a new book,
> for distribution purpose (with VBA or manually, it doesn't matter)
>
> Problem: After the procedure is done, the "Calculate" remains in statusbar,
> even when I close the source book and the copy book and no book is active.
>
> What's the reason for that behaviour?
>
> Thanks for your support.
> Werner

Thanks Tushar and Tom,
I guess that I exceed the limit of some 65,536 dependencies to unique
references by copying the sheets including the formula to a new book.

Best Regards
Werner