XlPivotTableMissingItems Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies the maximum number of unique items per PivotField allowed.
public enum class XlPivotTableMissingItemspublic enum XlPivotTableMissingItemsPublic Enum XlPivotTableMissingItems- Inheritance
-
XlPivotTableMissingItems
Fields
| Name | Value | Description |
|---|---|---|
| xlMissingItemsDefault | -1 | The default number of unique items per PivotField allowed. |
| xlMissingItemsNone | 0 | No unique items per PivotField allowed (zero). |
| xlMissingItemsMax | 32500 | The maximum number of unique items per PivotField allowed (32,500). |
| xlMissingItemsMax2 | 1048576 | The maximum number of unique items per PivotField allowed (10,48,576) for a pre-short_Excel2007 PivotTable. |