This topic has not yet been rated - Rate this topic

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


Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ