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

ClassicLayout

ValuesLabelOnRow

EmptyValueCaption

FriendlyErrorCaption

ItemsToRetain

RefreshOnOpen

ShowEmptyValueCaption

ShowFriendlyErrorCaption