Skip to end of metadata
Go to start of metadata

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

ClassicLayout

Sets or returns whether the PivotTable will display in classic layout mode

ValuesLabelOnRow

Sets or returns whether the values labels field should be placed as a Row Label or Column Label

EmptyValueCaption

Sets or returns the caption displayed in place of a empty cell.

FriendlyErrorCaption

Sets or returns the caption displayed in place of an error.

ItemsToRetain

The ItemsToRetain class represents the number of items a PivotTable cache will retain even changes have been made to the data source.

RefreshOnOpen

Sets or returns whether Microsoft Excel will automatically refresh a PivotTable and the PivotTable cache when Excel opens the document.

ShowEmptyValueCaption

Sets or returns whether Microsoft Excel will automatically show a caption in place of a empty cell.

ShowFriendlyErrorCaption

Sets or returns whether Microsoft Excel will automatically show a caption in place of an error.
  • No labels