Applies To
PivotTable Object.
Description
Accessor. Returns an object that represents a single pivot field (a PivotField object, Syntax 1) or a collection of the pivot fields (a PivotFields object, Syntax 2) which are currently showing as data fields. Read-only.
Syntax 1
object.DataFields(index)
Syntax 2
object.DataFields
object
Required. The PivotTable object.
index
Required for Syntax 1. The name or number of the pivot field to return (can be an array to specify more than one).
See Also
ColumnFields Method, HiddenFields Method, PageFields Method, PivotFields Method, RowFields Method, VisibleFields Method.
Example
This example adds the PivotTable data field names to a list box. The list box appears on Sheet1.
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable Set newListBox = Worksheets("Sheet1").ListBoxes.Add _ (Left:=10, Top:=72, Width:=144, Height:=144) For Each dtaField In pvtTable.DataFields newListBox.AddItem (dtaField.Name) Next dtaField Worksheets("Sheet1").Activate