PivotFields object (Excel)

A collection of all the PivotField objects in a PivotTable report.


In some cases, it may be easier to use one of the properties that returns a subset of the PivotTable fields. The following properties are available:


Use the PivotFields method of the PivotTable object to return the PivotFields collection.

The following example enumerates the field names in the first PivotTable report on Sheet3.

With Worksheets("sheet3").PivotTables(1) 
 For i = 1 To .PivotFields.Count 
 MsgBox .PivotFields(i).Name 
End With

Use PivotFields (index), where index is the field name or index number, to return a single PivotField object. The following example makes the Year field a row field in the first PivotTable report on Sheet3.

Worksheets("sheet3").PivotTables(1) _ 
 .PivotFields("year").Orientation = xlRowField



See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.