Pivo table Field drop-down arrow

[Gunnar Sandström]

Hi!
I want to have all items under the field drop down arrow in a Pivo table to
become unselected.

I have pivo tables with hundreds of items where i want to select a few.
It is to much work to first manually unselect all of them.
/// Gunnar

 

[Debra Dalgleish]

You can use a macro to show or hide the items. There's sample code here:

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