Ask Your Question

Copy a functional pivot table [closed]

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

byslexic gravatar image

updated 2013-10-22 19:49:57 +0100

manj_k gravatar image

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?


edit retag flag offensive 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

2 Answers

Sort by » oldest newest most voted

answered 2013-01-04 03:54:17 +0100

kohei gravatar image

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.

edit flag offensive delete link 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?

byslexic gravatar imagebyslexic ( 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".

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

answered 2013-01-05 06:39:17 +0100

kohei gravatar image

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

edit flag offensive delete link more

Question Tools

1 follower


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

Seen: 7,653 times

Last updated: Jan 05 '13