I have code that selects a name on the slicer which is True, it then updates (refreshes), then it goes through unselecting the rest of the names - but while unselecting all the names - it keeps updating and refreshing.
However if i was to do this manually (not using VBA) - i would select the first name, pivot tables refresh and then the rest of the names are auto unselected - can i mimick this in VBA?
Basically its currently faster to run the report in excel by selecting names etc
So can i get vba to select a name from a slicer list, refresh and unselect the other names without all tghe refreshes?
.SlicerItems("1_NO REGIONAL SALES MANAGER").Selected = True
Application.EnableEvents = False
.SlicerItems("Dave, dennis").Selected = False
.SlicerItems("Bob, dave").Selected = False