XlPivotTableMissingItems enumeration (Microsoft.Office.Interop.Excel)

XlPivotTableMissingItems enumeration

Office 2013 and later

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)

Syntax

No code example is currently available or this language may not be supported.

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