Export (0) Print
Expand All
Expand Minimize

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

ADD
Show:
© 2014 Microsoft