Wiki Markup |
---|
{introducedin: 8.4} {description} {excerpt}The {{[PivotTableSettings|PivotTableSettings]}} class contains the set of properties specific to pivot tables. To get a {{PivotTableSettings}} object, use {{[PivotTable.PivotTableSettings|PivotTable.PivotTableSettings]}}.{excerpt} {signature:C#} public sealed class PivotTableSettings {signature}{signature:vb.net} Public NotInheritable Class PivotTableSettings {signature} {properties} || Name || Description || | [ClassicLayout|PivotTableSettings.ClassicLayout] | {excerpt-include:PivotTableSettings.ClassicLayout|nopanel=true} | | [ValuesLabelOnRow|PivotTableSettings.ValuesLabelOnRow] | {excerpt-include:PivotTableSettings.ValuesLabelOnRow|nopanel=true} | | [EmptyValueCaption|PivotTableSettings.EmptyValueCaption] | {excerpt-include:PivotTableSettings.EmptyValueCaption|nopanel=true} | | [FriendlyErrorCaption|PivotTableSettings.FriendlyErrorCaption] | {excerpt-include:PivotTableSettings.FriendlyErrorCaption|nopanel=true} | | [ItemsToRetain|ItemsToRetain] | {excerpt-include:ItemsToRetain|nopanel=true} | | [RefreshOnOpen|PivotTableSettings.RefreshOnOpen] | {excerpt-include:PivotTableSettings.RefreshOnOpen|nopanel=true} | | [ShowEmptyValueCaption|PivotTableSettings.ShowEmptyValueCaption] | {excerpt-include:PivotTableSettings.ShowEmptyValueCaption|nopanel=true} | | [ShowFriendlyErrorCaption|PivotTableSettings.ShowFriendlyErrorCaption] | {excerpt-include:PivotTableSettings.ShowFriendlyErrorCaption|nopanel=true} | |
Page History
Overview
Content Tools