Copying Pivot tables (How to)

L

Lebowski

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
 
M

Max

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
 
Top