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