XlPivotTableMissingItems XlPivotTableMissingItems XlPivotTableMissingItems Enum

Definition

Specifies the maximum number of unique items per PivotField allowed.

public enum class XlPivotTableMissingItems
public enum XlPivotTableMissingItems
Public Enum XlPivotTableMissingItems
Inheritance
XlPivotTableMissingItemsXlPivotTableMissingItemsXlPivotTableMissingItems

Fields

xlMissingItemsDefault xlMissingItemsDefault xlMissingItemsDefault -1

The default number of unique items per PivotField allowed.

xlMissingItemsMax xlMissingItemsMax xlMissingItemsMax 32500

The maximum number of unique items per PivotField allowed (32,500).

xlMissingItemsMax2 xlMissingItemsMax2 xlMissingItemsMax2 1048576

The maximum number of unique items per PivotField allowed (10,48,576) for a pre-short_Excel2007 PivotTable.

xlMissingItemsNone xlMissingItemsNone xlMissingItemsNone 0

No unique items per PivotField allowed (zero).

Applies to