Pivot table : bulk field selection

[AlfD]

Hi!

Does anyone know a quick way to delete all or select all (or blocks) o
the little checkboxes used for selecting fields to display? It can ge
very tedious clicking down the lists.

Al

 

[Debra Dalgleish]

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

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

 

[AlfD]

Debra:

Thanks! Hits all the right buttons.

Al