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:

  1. If literally using Copy, copy the entire sheet.
    or
  2. Right click the existing pivot table, select Edit Layout and click More. In Result to select another location, same sheet or not.

Solution 2:

  1. Select the Pivot Table
  2. On the Analyze Ribbon - Click on Select-> Entire Pivot Table
  3. Right Click Copy in the pivot table area
  4. 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:

  1. From Pivot Table 1, select any cell, then click CTRL-Shift-* (selects entire pivot table)
  2. Click CTRL-C (copy)
  3. 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.