This documentation is archived and is not being maintained.

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


Show: