XlPivotTableMissingItems Enumeration
Specifies the maximum number of unique items allowed per PivotField.
Version Information
Version Added: Excel
| 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 PivotTable. |
| xlMissingItemsMax2 | 1048576 | The maximum number of unique items per PivotField allowed (10,48,576) for a pre-Excel PivotTable. |
| xlMissingItemsNone | 0 | No unique items per PivotField allowed (zero). |