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