Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

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

EmptyValueCaption

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

FriendlyValueCaption

The page EW8:PivotTableSettings.FriendlyValueCaption could not be found.

RefreshOnOpen

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