This documentation is archived and is not being maintained.

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)

'Usage
Dim xlPivotTableMissingItems1 As XlPivotTableMissingItems = XlPivotTableMissingItems.xlMissingItemsDefault

public enum XlPivotTableMissingItems
public enum XlPivotTableMissingItems
public enum XlPivotTableMissingItems

Member nameDescription
xlMissingItemsDefaultThe default number of unique items per PivotField allowed.
xlMissingItemsMaxThe maximum number of unique items per PivotField allowed (32,500).
xlMissingItemsNoneNo unique items per PivotField allowed (zero).

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Show: