PivotTable.DataFields Property

Syntax

expression.DataFields(Index)

expression A variable that represents a PivotTable object.

Parameters

Name	Required/Optional	Data Type	Description
Index	Optional	Variant	The field name or number (can be an array to specify more than one field).

Example

This example adds the names for the PivotTable data fields to a list on a new worksheet.

Visual Basic for Applications

Visual Basic for Applications
`Set nwSheet = Worksheets.Add nwSheet.Activate Set pvtTable = Worksheets("Sheet2").Range("A1").PivotTable rw = 0 For Each pvtField In pvtTable.DataFields rw = rw + 1 nwSheet.Cells(rw, 1).Value = pvtField.Name Next pvtField`

Set nwSheet = Worksheets.Add nwSheet.Activate Set pvtTable = Worksheets("Sheet2").Range("A1").PivotTable rw = 0 For Each pvtField In pvtTable.DataFields rw = rw + 1 nwSheet.Cells(rw, 1).Value = pvtField.Name Next pvtField

data fields Data Fields Property DataField datafield property datafields datafields property Retrieve a specific pivot data field? Return the collection of all datafields for a pivot table?

Returns an object that represents either a single PivotTable field (a PivotField object) or a collection of all the fields (a PivotFields object) that are currently shown as data fields. Read-only.

See also: