Class DefaultPivotTableLayoutOptions (Excel VBA)

Default PivotTable layout options

Class Application gives access to class DefaultPivotTableLayoutOptions.

Member in collection

Item

To use a DefaultPivotTableLayoutOptions class variable it first needs to be instantiated, for example

Dim dpts as DefaultPivotTableLayoutOptions
Set dpts = Application.DefaultPivotTableLayoutOptions

DefaultPivotTableLayoutOptions class variables can be set using the Application.DefaultPivotTableLayoutOptions procedure.

Properties

AllowMultipleFilters

CalculatedMembersInFilters

ColumnGrand

CompactRowIndent

DisplayContextTooltips

DisplayEmptyColumn

DisplayEmptyRow

DisplayErrorString

DisplayFieldCaptions

DisplayImmediateItems

DisplayMemberPropertyTooltips

DisplayNullString

EnableDrilldown

EnableWriteback

ErrorString

FieldListSortAscending

HasAutoFormat

InGridDropZones

LayoutBlankLine

MergeLabels

NullString

PageFieldOrder

PageFieldWrapCount

PreserveFormatting

PrintDrillIndicators

PrintTitles

RefreshOnFileOpen

RepeatAllLabels

RepeatItemsOnEachPrintedPage

RowAxisLayout

RowGrand

SaveData

ShowDrillIndicators

ShowValuesRow

SortUsingCustomLists

SubtotalHiddenPageItems

SubtotalLocation

Subtotals

TotalsAnnotation

ViewCalculatedMembers

VisualTotals

VisualTotalsForSets

xlMissingItemsNone