CODEWITHSUNDEEP
excelpivot-tableslicers
mitchmitch24
mitchmitch24

Reputation: 383

Slicer wont connect to multiple pivot tables?

I have quite a few pivot tables (all connected to the same data source) however when I create a slicer and edit the pivot connections, it only shows one pivot table (the one I selected the slicer from.)

Note: The data they are all connected to is a named range.

Any idea how to fix this so I can connect the slicer to all of the tables?

Thanks!

Upvotes: 0

Views: 4419

Answers (1)

jeffreyweir
jeffreyweir

Reputation: 4824

Change your data source to an Excel Table (aka ListObject) and then repoint the PivotTables to it. Named Ranges probably don't count as 'the same data source' from Excel's perspective, if the named range dimensions grow/shrink between the creation of one PivotTable and another. But Tables do.

Upvotes: 0

Related Questions