This documentation is archived and is not being maintained.

XlPivotFieldDataType Enumeration

Office 2007
Specifies the type of data in the PivotTable field.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlDate2Contains a date.
xlNumber-4145Contains a number.
xlText-4158Contains text.

Remarks

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



Show: