Compartilhar via


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)

Syntax

'Declaration
Public Enumeration XlPivotTableMissingItems
'Usage
Dim instance As XlPivotTableMissingItems
public enum XlPivotTableMissingItems

Members

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.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace