PivotFields Property [Excel 2003 VBA Language Reference]

  • Article

Returns the PivotFields 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

Applies to | CubeField Object

See Also | ColumnFields Property | DataFields Property | HiddenFields Property | PageFields Property | RowFields Property | VisibleFields Property