changes.mady.by.user Alison Bird [softartisans]
Saved on Sep 27, 2012
...
Name
Description
Max
Value
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.
PivotTableSettings.ItemsToRetain