The ItemsToRetain class represents the number of items a PivotTable Cache will retain.
public sealed class ItemsToRetain
Public NotInheritable Class ItemsToRetain
ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Create(); ItemsToRetain items = wb[0].PivotTables[0].PivotTableSettings.ItemsToRetain;
Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Create() Dim pal As ItemsToRetain = wb[0].PivotTables[0].PivotTableSettings.ItemsToRetain;
Name
Description
Automatic
None
Max
Value