Select the pivot/parts thereof*, then click Edit Copy (from the menu
command) to copy,
then do the paste special as values & as formats
*either manually (for parts) or via right-click inside the pivot Select
Entire Table
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"eggman2001" wrote in message
...
How do I 'copy pivot table'? Select All | Copy ?

If I do Paste Special in a new workbook, it tries to link the paste
back to the original workbook, which I don't want.