Hi,

is there any possibility to copy a pivot table from one spreadsheet to
another? I know its possible to simply copy pivot's values but I need
not only values but a complete pivot, with all its data, formulas so I
could operate on and modify him.

Thanks for help

1. Just make a copy of the sheet with the pivot/s ?
(eg right-click on the sheet tab move or copy check "create a copy"
ok)

2. Select just the pivot.
Right-click on any cell within the pivot Select Entire table
Click Edit Copy (from the menu bar).
In a new sheet, right-click on say, B2 Paste
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lebowski" wrote in message
oups.com...
Hi,

is there any possibility to copy a pivot table from one spreadsheet to
another? I know its possible to simply copy pivot's values but I need
not only values but a complete pivot, with all its data, formulas so I
could operate on and modify him.

Thanks for help