Expand Minimize

XlPivotTableMissingItems Enumeration (Excel)

Published: July 16, 2012

Specifies the maximum number of unique items allowed per PivotField.

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

Community Additions

ADD
Show:
© 2014 Microsoft