PivotTable.PivotFields (Excel)

Returns an pivotfields that represents either a single PivotTable field (a PivotField) or a collection of both the visible and hidden fields (a PivotFields collection) in the PivotTable report. Read-only.

For OLAP data sources, there are no hidden fields, and the object or collection that is returned reflects what's currently visible.

PivotFields (Index)

Index: The name or number of the field to be returned.


Dim pfs As PivotFields
Set pfs = ActiveCell.PivotTable.PivotFields()