# Copy a functional pivot table [closed]

I keep having to recreate the same pivot table over and over, then change the filter in each instance in order to sort and summarize a large table of data by month.

Is there no way to quickly copy a functional pivot table, so as to apply and display differently filtered data?

Thanks!

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-19 19:26:17.446184

Sort by » oldest newest most voted

There are several ways to do this, but probably the easiest way, if you are okay with having one pivot table per sheet, is to copy the sheet with the pivot table on. Then the new sheet will have a functional copy of the original pivot table.

more

Thanks Kohei - that seems to work. You mentioned that there are several ways, and I'd like to know another one.

If I want 12 copies of the pivot table (one per month), I have to add 12 sheets to my workbook, which is a bit ungainly, though would do the trick. How else can this be accomplished?

( 2013-01-04 20:27:58 +0100 )edit

I'm doing something like that. I have 12 sheets and other 12 sheets with pivot tables, one for each normal sheet. I copy the pivot table first (right click on the tab > "Move/Copy Sheet" > Action "Copy" > New name > OK). Then i do the same with the normal sheet. And then i just relate both sheets together editing the Pivot Table Layout > "+ Source and Destination" > Source: Selection "$name_of_sheet.$cell range".

( 2017-12-21 20:32:24 +0100 )edit

Another way is as follows.

1. Right-click on the original pivot table and choose Edit Layout...
2. Click on 'More' to expand the bottom part of the dialog.
3. In the "Result to" box, select the cell position of where you want the new table to be. Leave the pull-down list box to "- undefined -".
4. Then click OK.

This will create a copy of the original to the specified location. This way you can have multiple copies on the same sheet (if you so wish).

more

## Stats

Asked: 2013-01-04 02:25:12 +0100

Seen: 7,653 times

Last updated: Jan 05 '13