Is it possible to copy & paste a pivot table in a spreadsheet?
Solution 1:
A copy will update if created with Paste Link.
Edit But as @Sekhemty points out, such a copy does not provide all the (in this case required) facilities of a pivot table. So:
- If literally using Copy, copy the entire sheet.
or - Right click the existing pivot table, select Edit Layout and click
More
. InResult to
select another location, same sheet or not.
Solution 2:
- Select the Pivot Table
- On the Analyze Ribbon - Click on Select-> Entire Pivot Table
- Right Click Copy in the pivot table area
- Go to the location where you want to place the copy of the pivot table and right click and select Paste Special ->Keep Source Column Widths (W)
This should give you what you need. Hope this helps
Solution 3:
- From Pivot Table 1, select any cell, then click CTRL-Shift-* (selects entire pivot table)
- Click CTRL-C (copy)
- Click mouse into new cell on same or different worksheet - Press ENTER
This will create a copy of Pivot Table 1 as Pivot Table 2 that you can than Change Data Source but otherwise all of your fields and formatting are preserved.