Expand Minimize

PivotTable.DataPivotField Property (Excel)

Returns a PivotField object that represents all the data fields in a PivotTable. Read-only.

expression .DataPivotField

expression A variable that represents a PivotTable object.

This example moves the second PivotItem object to the first position. It assumes a PivotTable exists on the active worksheet and that the PivotTable contains data fields.

Sub UseDataPivotField() 
 
 Dim pvtTable As PivotTable 
 
 Set pvtTable = ActiveSheet.PivotTables(1) 
 
 ' Move second PivotItem to the first position in PivotTable. 
 pvtTable.DataPivotField.PivotItems(2).Position = 1 
 
End Sub

Community Additions

ADD
Show:
© 2014 Microsoft