Group the sheets and copy then all at once.

--
Regards,
Tom Ogilvy

"andym" wrote in message
...
Me Again!!

having successfully been able to copy 5 sheets of an original workbook
into
a new workbook, I am having problems where all my links on charts etc are
linking back to the original workbook.

Is there any way that I can set the data series of the charts to stay with
the accompanying data sheet, not the original workbook?

Of the 5 sheets I have copied over into their own workbook, 1 is the data,
the other the charts themselves.

Again, your help would be appreciated...

Regards,

andy m