The PivotTableSettings class contains the set of properties specific to pivot tables. To get a PivotTableSettings object, use PivotTable.PivotTableSettings.

 public sealed class PivotTableSettings
Public NotInheritable Class PivotTableSettings

Name

Description

EmptyValueCaption

FriendlyValueCaption

RefreshOnOpen