updating all slicers at one time

New Contributor

Hello everyone,


I'm trying hard with excel since 2 days.


I have about 10 slicers related to my Pivot tables and I would like to filter first all my slicers before reloading my tables and getting the data I want. Excel refresh slicer by slicer and it takes a lot of time. Is there anything I can do to change this ? not refresh my slicer until I click on a button  for exemple ?


To illustrate what I want guys : Simply; I would like to filtrer my data on a shop, a division, a season and a date for example AND THEN validate my choices to refresh my data from my pivot tables and get what I want.

Is there any smart way to do that please ?


Thanks a lot,





1 Reply
I received the same requirements. Hope someone can work out a solution