Expand Minimize

XlPivotTableMissingItems Enumeration

Specifies the maximum number of unique items per PivotField allowed.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

public enum XlPivotTableMissingItems

Member nameDescription
xlMissingItemsDefaultThe default number of unique items per PivotField allowed.
xlMissingItemsNoneNo unique items per PivotField allowed (zero).
xlMissingItemsMaxThe maximum number of unique items per PivotField allowed (32,500).
xlMissingItemsMax2The maximum number of unique items per PivotField allowed (10,48,576) for a pre-short_Excel2007 PivotTable.
Show:
© 2015 Microsoft