Is it possible to copy & paste a pivot table in a spreadsheet

copy/pastelibreofficelibreoffice-calcpivot tablespreadsheet

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?

Best Answer

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.
Related Question