Share via

XlPivotTableMissingItems Enumeration

  • Article

Specifies the maximum number of unique items allowed per PivotField.

Version Information
 Version Added:  Excel 2007

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