XlPivotTableMissingItems Enumeration
TOC
Collapse the table of content
Expand the table of content

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 (10,48,576) for a pre-Excel 2007 PivotTable.

xlMissingItemsNone

0

No unique items per PivotField allowed (zero).

Show:
© 2016 Microsoft