.
| 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} | |