robinssdawn
New member
- Joined
- Nov 30, 2017
- Messages
- 7
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
I have 9 pivot tables in Excel 2010 that all have the same field lists just different views of the data.
Currently for each one, i have to go into Change Data Source to update each one. Excel 2007 had a feature in the Pivot table Wizard ( i do believe) where i could link the tables. When one is updated they ALL update.
Obviously in 2010, this does not exist and i really need it to.
I don't know how to use the slicer and not sure if that will answer my issue anyway.
also, i tried copying a pivot table and pasting as Paste Link but then the field list was not attached to it nor are any of the Pivot table options in the Ribbon.
How can i tie all of these tables together so when i update the first one, they all update?
Currently for each one, i have to go into Change Data Source to update each one. Excel 2007 had a feature in the Pivot table Wizard ( i do believe) where i could link the tables. When one is updated they ALL update.
Obviously in 2010, this does not exist and i really need it to.
I don't know how to use the slicer and not sure if that will answer my issue anyway.
also, i tried copying a pivot table and pasting as Paste Link but then the field list was not attached to it nor are any of the Pivot table options in the Ribbon.
How can i tie all of these tables together so when i update the first one, they all update?