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,

 

 

melissa95_0-1639041265138.png

 

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