Partager via

XlPivotTableMissingItems Enumeration

  • Article

Specifies the maximum number of unique items allowed per PivotField.

Version Information

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