Dec 09 2021 01:21 AM - edited Dec 09 2021 08:20 AM
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,
Mar 28 2022 01:37 AM