Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

XlPivotTableMissingItems Enumeration

Office 2007
Specifies the maximum number of unique items allowed per PivotField.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlMissingItemsDefault-1The default number of unique items per PivotField allowed.
xlMissingItemsMax32500The maximum number of unique items per PivotField allowed (32,500) for a pre-Excel 2007 PivotTable.
xlMissingItemsMax21048576The maximum number of unique items per PivotField allowed (10,48,576) for a pre-Excel 2007 PivotTable.
xlMissingItemsNone0No unique items per PivotField allowed (zero).


Community Additions

Show: