Returns an object that represents either a single PivotTable item (a PivotItem object, Syntax 1) or a collection of all the visible and hidden items (a PivotItems object, Syntax 2) in the specified field. Read-only.
Syntax 1
expression.PivotItems(Index)
Syntax 2
expression.PivotItems
expression Required. An expression that returns a PivotField object.
Index Optional Variant. The name or number of the item to be returned.
Remarks
For OLAP data sources, the collection is indexed by the unique name (the name returned by the SourceName property), not by the display name.