PivotItems-Slow For Each Loop

[jomili]

I have a pivot field, Label, which has about 8K pivotitems. When I come into the pivot table (I don't create it) some of the 8K items are turned off. I want to turn them all on. The top code below does it, but it takes forever. I'd like to streamline it, and was trying to in the Test2 sub, but I get an error on the "Pi.visible" line saying "Object Variable or With block variable not set".

Any help in speeding up this code would be greatly appreciated.

Please Login or Register  to view this content.