Doesn't look like a VBA error. What kind of code are you runnng?

"Helge's" wrote:

I have a macro consisting of ADO-code, pivottable-code etc. And copying
sheets (80) to a new book. Sometimes an errror occur (Run-Time-Error :
-2147417847 (80010108) - Automatin error. The object invoked has
disconnected from its clients.

I cant find the solution. I hope any can help.

Helge