Hi Mr Rick,

Right-click the worksheet Tab, select 'Move or Copy' from the context menu.
Then select another workbook and check the 'create a copy' option.
The whole sheet will copy across, pivot tables will keep their formats.

Hope you all had a great Christmas, and Happy New Year to you.
Ed Ferrero
http://www.edferrero.com

When you move a pivot table graph to a new workbook the formatting will
change. How can I keep the exact formating of the graph?