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:
or
More
. InResult to
select another location, same sheet or not.