Compartilhar via


PivotCache.MissingItemsLimit Property

Returns or sets the maximum quantity of unique items per PivotTable field that are retained even when they have no supporting data in the cache records.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property MissingItemsLimit As XlPivotTableMissingItems
    Get
    Set
'Usage
Dim instance As PivotCache
Dim value As XlPivotTableMissingItems

value = instance.MissingItemsLimit

instance.MissingItemsLimit = value
XlPivotTableMissingItems MissingItemsLimit { get; set; }

Property Value

Type: Microsoft.Office.Interop.Excel.XlPivotTableMissingItems

Remarks

XlPivotTableMissingItems can be one of the following XlPivotTableMissingItems constants:

xlMissingItemsDefault The default number of unique items per PivotField allowed.

xlMissingItemsMax The maximum number of unique items per PivotField allowed (32,500).

xlMissingItemsNone No unique items per PivotField allowed (zero).

This property can be set to a value between 0 and 32500. If an integer less than zero is specified, this is equivalent to specifying xlMissingItemsDefault. Integers greater than 32,500 can be specified but will have the same effect as specifying xlMissingItemsMax.

The MissingItemsLimit property only works for non-OLAP PivotTables; otherwise, a run-time error can occur.

See Also

Reference

PivotCache Interface

PivotCache Members

Microsoft.Office.Interop.Excel Namespace