XlPivotTableMissingItems Enumeration (Excel)

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).