Ein in vielen Artikeln und Büchern und Foren beschriebener Weg, die Geschwindigkeit zu erhöhen, in dem man die Berechnung ausschaltet.
You can use programming to control the slicers, and this page has sample code that you can use.
When you select an item in one slicer, it will automatically select the same item in another slicer.
In this example, there is a pivot table based on a table with sales data, and a slicer for the City field. To move a slicer: After moving both the slicers, click on a city in the short city slicer, and the main pivot table should change, to show only the results for that city. The zipped file contains macros, so enable macros to test the slicers. Download a completed sample file that has two sets of Slicers (one for City, one for Category).
The source data has four cities, and we only want Boston and Los Angeles available in the slicer The slicer shows all the items, and we can't hide the cities that we don't want to use. Name) Set si Short = Nothing On Error Resume Next Set si Short = sc Short. Name) On Error Go To err Handler If Not si Short Is Nothing Then If si Short. If you check the slicer on the short list sheet, it should have changed, to show the same city (or cities) selected. The zipped file contains macros, so enable macros to test the slicers.
VBA programs are known to save a lot of time and now this post is to save further time. * An operation has been performed that forced Excel to calculate page breaks.