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. |