How would I reset a pivot table to that it shows all of the items without using loops? Currently, I am using a loop to go through each list and select all the items. This however takes an extremely long time. I have tried using .showAllItems = True but it doesn't seem to work. Any advice?
Bookmarks