filtering in pivot table

[suhair]

Hi,
How can i unmark in excel2000 all the items in a row or
column.
Thanks

 

[Debra Dalgleish]

You can use a macro to show or hide the items in a field. There is
sample code here:

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