Pivot Tables

E

ERR229

Does anyone know if there is a way to quickly clear a field list? I can't
find a keyboard shortcut or anything else in any of the help/support avenues
I've tried.

Thanks in advance for the help.
 
D

Debra Dalgleish

Are you trying to clear all the check boxes in the field's dropdown
list? In Excel 2002 and later versions, there's a Show All checkbox. In
Excel 2000, and earlier versions, you can use programming to hide or
show the items -- there's sample code here:

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

ERR229

Yes, I'm trying to clear the checkboxes (in 2000). I was hoping there was a
keyboard shortcut or something else that I had yet to discover. Alas, it
looks as though it's a manual process.

Thanks for the response.
 
Top