Returns an object that represents either a single hidden PivotTable item (a PivotItem object, Syntax 1) or a collection of all the hidden items (a PivotItems object, Syntax 2) in the specified field. Read-only.
Syntax 1
expression.HiddenItems(Index)
Syntax 2
expression.HiddenItems
expression Required. An expression that returns a PivotField object.
Index Optional Variant. The number or name of the item to be returned (can be an array to specify more than one item).
Remarks
For OLAP data sources, this property always returns an empty collection.