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

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 , werner-
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

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" wrote in message
...
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) wrote in message m...
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