Help setting PivotItems...
 

Is there a code to "ShowAll" in a PivotField? I have written a code that
correctly sets the visible property of unwanted dates to False. When I
refresh the PivotTable to a new list, I must show all items to run the code
again. Every time I try to run a code to set all items to true, I get a
run-time that says I cannot set the visible property of the PivotItem Class.

Help setting PivotItems...
 

Give this a look...

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

Jim Thomlinson


"Sam" wrote:

Is there a code to "ShowAll" in a PivotField? I have written a code that
correctly sets the visible property of unwanted dates to False. When I
refresh the PivotTable to a new list, I must show all items to run the code
again. Every time I try to run a code to set all items to true, I get a
run-time that says I cannot set the visible property of the PivotItem Class.