Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a spreadsheet where I use some pivot tables to summarize and highlight some relevant data.

Since I have to use multiple pivot tables, all with nearly the same data input but with slight differences from each other, I was thinking to create just one of them, then copy & paste it and subsequently modify only the data set that I need to change.

But when I try to do that (by selecting and copying the table cells), the paste operation gives me just the content of the source table, not the structure; so I will have a series of cells filled with the formatting and values from the source one, but that is not a pivot table itself, thus it won't update and basically is of no use.

I hope it is all clear. How can I do it?

share|improve this question
up vote 2 down vote accepted

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.
  2. Right click the existing pivot table, select Edit Layout and click More. In Result to select another location, same sheet or not.
share|improve this answer
But I need a completely new table, not a link, because I need to modify it with different data sets; I just want to use an existent one as a template, so to speak. – Sekhemty May 23 '13 at 17:11
Or combine both steps to get the copied table back on the same sheet (copy the entire sheet and then move the copies back to the original sheet). – kad81 Jul 29 '14 at 3:41
  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.

share|improve this answer

Right-click the worksheet tab at the bottom of the window, select Move or Copy, specify where you want to place the new worksheet, and make sure that "Create a copy" is checked. This will work to duplicate the PivotTable with the current layout; note that the tables will have the same name, however (if you interact with them via scripting, etc.). It also works best if you have only one PivotTable per worksheet.

Note: I see you tagged your post for LibreOffice. My directions are for Excel though they may be applicable to the former as well.

share|improve this answer
Altough working, this solution duplicate an entire worksheet, not just a single pivot table. I have a layout with more tables per worksheet, for ease of view and printing purposes – Sekhemty May 23 '13 at 21:51
Copying the entire sheet does indeed work for LibreOffice - see 1. in my answer. As I do not think it is useful to post the same answer as already offered (again!) I feel obliged to -1. – pnuts May 24 '13 at 0:18

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.