Sliceritem Issues

[BKNewton29]

I'm trying to create a report that appends branch reports next to each other based on cycling through sliceritems

The issue I have is that it is so slow because the pivots refresh everytime you select/deselect a sliceritem

My options are as follows

1 Turn off this refresh somehow until I've altered all the slicer items i need
2 Select just one sliceritem through VBA
3 VBA code a deselect all sliceritems in one go

I currently don't have any solutions to the three options above. (I'm not able to use a Powerpivot OLAP cube)

Any help appreciated

 

[yearnintolearn]

To do option 1 you would go to Formulas > Calculation options > Manual

 

[BKNewton29]

Sadly that doesn't work when looking at slicer manipulation and pivot caches

 

[BKNewton29]

I solved the issue by setting the pivot table update to manual

Worksheets(1)ivotTables("PivotTable2").ManualUpdate = True

and then changing it back to false after the slicers have been manipulated