Forum Discussion
Solved
How to link pivot tables
Hi! I distributed a survey and aggregated the results in Excel where each question and it's answers is its own pivot table. I would like to make the same type of changes to all pivot tables (e.g. move the order of the answer options to all the same thing) but so far, I have had to move them individually for each pivot table. Is there a way to link the pivot tables so that the change I make to one is carried over to all the other ones in the sheet?
BriWork You can read about slicers on my website: https://jkp-ads.com/articles/slicers.asp
- Why not create just one PT with the Question as a page field (or as a slicer!)?
- It's my first time working with PTs so I was unsure what to do as in the end I would also like to generate graphs of the responses to each question. I will look into page fields or slicers, since I haven't heard of them before.
BriWork You can read about slicers on my website: https://jkp-ads.com/articles/slicers.asp
