collection. This collection contains all PivotTable fields, including those that aren’t currently visible on-screen. Read-only PivotFields object.
expression.PivotFields
expression Required. An expression that returns a CubeField object.
Remarks
For Online Analytical Processing (OLAP) data sources, there are no hidden fields, and the object or collection that’s returned reflects what’s currently visible.
Example
This example creates a list of all the PivotTable field names used in the first PivotChart report.
Set objNewSheet = Worksheets.Add
objNewSheet.Activate
intRow = 1
For Each objPF In _
Charts("Chart1").PivotLayout.PivotFields
objNewSheet.Cells(intRow, 1).Value = objPF.Caption
intRow = intRow + 1
Next objPF