XlPivotFieldDataType Enumeration

Specifies the type of data in the PivotTable field.

Version Information

Version Added: Excel 2007

Name

Value

Description

xlDate

2

Contains a date.

xlNumber

-4145

Contains a number.

xlText

-4158

Contains text.

Remarks

This enumeration is used with the DataType property of the PivotField object.