Pivot Table row fields

[Clys]

Is there any way to uncheck all of the boxes at once in my row field
drop down box. Example: I have dragged years into the row field. A
drop down arrow shows but everything is checked. I do not want to have
to uncheck these one at a time. Thank you for your help.

 

[Debra Dalgleish]

There's some sample code here that shows/hides items in a pivot table:

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