Introduced in build 8.3
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 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. |