Copy a functional pivot table

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!

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.

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?

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”.

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).