Pivot Table Lists

[ED]

One field in my pivot table has 100 items. Is there short
cut for selecting/deselecting all the items rather than
going through each one?

 

[Debra Dalgleish]

There's sample code here that you can use to hide or show items:

http://www.contextures.com/xlPivot03.html