.
Introduced in build 8.4
Description
The PivotTableSettings class contains the set of properties specific to pivot tables. To get a PivotTableSettings object, use PivotTable.PivotTableSettings.
C#
vb.net
Properties
Name |
Description |
|---|---|
| Sets or returns whether the PivotTable will display in classic layout mode | |
| Sets or returns whether the values labels field should be placed as a Row Label or Column Label | |
| Sets or returns the caption displayed in place of a empty cell. | |
| Sets or returns the caption displayed in place of an error. | |
| The ItemsToRetain class represents the number of items a PivotTable cache will retain even changes have been made to the data source. | |
| Sets or returns whether Microsoft Excel will automatically refresh a PivotTable and the PivotTable cache when Excel opens the document. | |
| Sets or returns whether Microsoft Excel will automatically show a caption in place of a empty cell. | |
| Sets or returns whether Microsoft Excel will automatically show a caption in place of an error. |