XlPivotTableMissingItems 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 maximum number of unique items allowed per PivotField.

Name

Value

Description

xlMissingItemsDefault

-1

The default number of unique items per PivotField allowed.

xlMissingItemsMax

32500

The maximum number of unique items per PivotField allowed (32,500) for a pre-Excel 2007 PivotTable.

xlMissingItemsMax2

1048576

The maximum number of unique items per PivotField allowed (1,048,576) for PivotTables in Excel 2007 and later.

xlMissingItemsNone

0

No unique items per PivotField allowed (zero).

Show: