Skip to end of metadata
Go to start of metadata

Introduced in build 8.4

Description

The ItemsToRetain class represents the number of items a PivotTable cache will retain even changes have been made to the data source.
C#
vb.net

Examples

C#
vb.net

Remarks

Setting PivotTableSettings.ItemsToRetain is the same as going to PivotTable Options > Data > Retain items deleted from the data source and setting Number of items to retain per field to Automatic, Max, None, or a different integer value.

Fields

Name

Description

Automatic

ItemsToRetain's value for automatic.

None

ItemsToRetain's value for none.

Properties

Name

Description

Max

Returns the maximum number of items the PivotTable's cache can support.

Value

Sets or Returns the current number of items the PivotTable's cache is set to retain.

 

 

  • No labels