Forum Discussion
melissa95
Dec 09, 2021Copper Contributor
updating all slicers at one time
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
Sort By
- ProviderMSOLAP8PersCopper ContributorI received the same requirements. Hope someone can work out a solution