XlPivotTableMissingItems Enum

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Specifies the maximum number of unique items per PivotField allowed.

public enum class XlPivotTableMissingItems

public enum XlPivotTableMissingItems

Public Enum XlPivotTableMissingItems

Inheritance

Enum

XlPivotTableMissingItems

Fields

xlMissingItemsDefault	-1	The default number of unique items per PivotField allowed.
xlMissingItemsMax	32500	The maximum number of unique items per PivotField allowed (32,500).
xlMissingItemsMax2	1048576	The maximum number of unique items per PivotField allowed (10,48,576) for a pre-short_Excel2007 PivotTable.
xlMissingItemsNone	0	No unique items per PivotField allowed (zero).