.
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
Fields
Name |
Description |
|---|---|
ItemsToRetain's value for automatic. |
|
ItemsToRetain's value for none. |
Properties
Name |
Description |
|---|---|
| Returns the maximum number of items the PivotTable's cache can support. | |
| Sets or Returns the current number of items the PivotTable's cache is set to retain. |
Remarks
SettingPivotTableSettings.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.