Linking / Duplicating Slicers Across Multiple Sheets

I have the following situation:
A workbook that utilizes PowerPivot / Data Model
Several Pivot Tables/Charts that are linked to the Data Model
Alike-Slicers (filtering the same field) existing across multiple sheets connected to the same Pivot Tables.

My Question:
How do I structure the Data Model, Pivot Tables, and/or the Slicers so that when a Slicer filters its connected table the Alike-Slicers make the same filtering-selections on different worksheets.

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hello,
that contest was held 5 years ago, so there may be different approaches now.

I find that the following works in both Excel 2010 and Excel 2013

- create pivot tables and pivot charts on the different sheets
- on one sheet add the desired slicer
- connect the slicer to all the pivot tables
- copy the slicer
- paste the slicer to the other sheets

Now, when I change the slicer selection, all pivots get updated, and all slicers are syncronized to the same setting.

cheers, teylyn

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Cool, the reason I didn't think this worked is.... a few months back I made a worksheet with slicers that filtered pivot tables/charts. Then on a separate sheet I connected slicers that filtered a regular table (the table the pivots were based off of).

So I guess my real question is.....Is there anyway for a slicer to be connected to a regular table and a pivot table?

Or.... Am I better of creating some sort of "get data" macro that essentially double clicks the pivot table and opens a new sheet with the data post filtering by a slicer?