PivotFields Property

Microsoft Excel Visual Basic

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