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). |
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.