If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Syncing multiple slicers from different pivot tables

Thread starter Hartke2421
Start date Oct 15, 2012
Tags

connection macro pivot table pivot table fields slicers

Hartke2421

New Member

Oct 15, 2012

I have a workbook with about 15 pivot tables. These pivot tables are linked to an Access database that holds the data and runs off of 5 queries. I am able to connect slicers so that I can minimize the number of slicers needed to 5, but I would still like to be able to use only 1 slicer to change all of the pivot tables. The field that I am trying to change in all of the pivot tables is the exact same for all of them, and it has the exact same items in it.

Is there a macro that can do this? I've been looking around for months for a solution to this, but can't seem to come up with anything. This would make my workbooks SOOO much cleaner. Is this something that PowerPivot can accomplish?