PivotTable.HiddenFields (Excel)

Returns an pivotfield that represents either a single PivotTable field (a PivotField) or a collection of all the fields (a PivotFields collection) that are currently not shown as row, column, page, or data fields. Read-only.

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

HiddenFields (Index)

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

Dim pvtfHiddenFields As PivotField
Set pvtfHiddenFields = ActiveCell.PivotTable.HiddenFields