XlPivotFieldDataType Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Specifies the type of data in the PivotTable field.

Name

Value

Description

xlDate

2

Contains a date.

xlNumber

-4145

Contains a number.

xlText

-4158

Contains text.

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

Show: