I'm trying to deselect all slicer items, using the following;
However, at the end of the sub, all items appear selected again! Help!Please Login or Register to view this content.
I'm trying to deselect all slicer items, using the following;
However, at the end of the sub, all items appear selected again! Help!Please Login or Register to view this content.
Sorted it. Falls over on the last, since you can't have nothing selected in a slicer.
So there is no way to deselect all slicer items?
What was your workaround? Manipulate pivot table filters using VBA instead?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks