The ItemsToRetain class represents the number of items a PivotTable cache will retain even changes have been made to the data source. |
public sealed class ItemsToRetain |
Public NotInheritable Class ItemsToRetain |
|
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. |
Name | Description |
---|---|
Name | Description |
---|---|