I'd get a copy of Debra Dalgleish's addin:
http://contextures.com/xlPivotAddIn02.html
and
http://contextures.com/xlPivotAddIn.html

That's one of the features she's included.

aramancam wrote:

Is there a way in Excel 2000 to easily select all or de-select all in the
drop down lists that the pivot table provides for each field? Right now I
have to manually select or de-select.

--

Dave Peterson