PivotField.HiddenItems (Excel)

Returns an pivotitem that represents either a single hidden PivotTable item (a PivotItem) or a collection of all the hidden items (a PivotItems collection) in the specified field. Read-only.

For OLAP data sources, this property always returns an empty collection.

HiddenItems (Index)

Index: The number or name of the item to be returned (can be an array to specify more than one item).

Dim pvtiHiddenItems As PivotItem
Set pvtiHiddenItems = ActiveCell.PivotField.HiddenItems