is it possible to make all 'pivot items' TRUE?

[t16turbo]

hi, in my macro, I have a stage where I need to interrogate a pivot table with some of the pivot items set to False.

I need to rest the pivot table afterwards, so that all items are displayed.

is there a way to do this without specifying each item?

PivotItems.("itemname").True, will do it on an individual basis, but I'm hoping for a blanket command!

 

[SkipVought]

Hi,

Maybe something like this...

for each pvi in Activesheet.PivotTables(1).PivotFields(1).PivotItems
  pvi.Visible = True
Next

Skip,

_{[red]Be Advised![/red]
A wee deranged psychic may be runnin' around out there!
SMALL MEDUIM @ LARGE}