How to reset slicers on multiple sheets/tabs

[Anonymous]

Hello,

  I want to create a master reset button that will reset all of the slicers in my report. I have multiple report pages and each page has two slicers. I created a bookmark called Home/Reset and I can reset the slicers on the first page, but I do not know how to include the slicers on the other pages. What ideas do you have?

Cheers,

Peter

[patBear]

@Anonymous Did you ever get this figured out?  I've been fiddling with bookmarks, and it seems you can create a bookmark, right click on it, and turn off "Current page" if you want slicers on other pages to be impacted by the bookmark settings.  Of course, you can then create a button whose action is this bookmark.

[Anonymous]

Is there any other way than having invisible synched slicers?

[patBear]

I don't know of any because bookmarks seem specific to a single page.

[Anonymous]

Thanks for the reply. I would need to have about 16 invisible slicers on my first page. Is there some other way, perhaps a way to select the slicers on the different pages?

Cheers!

[patBear · Accepted solution]

@Anonymous What if you have all of the slicers on your first page, just hide the ones you don't want to actually show on that page.  If you sync these first-page sliders with the other pages, then resetting them on the first page would reset them on the other pages too.  I haven't actually tried this, but it seems like it would work.  Good luck.