Class DefaultPivotTableLayoutOptions (Excel VBA)

Default PivotTable layout options

Properties

AllowMultipleFilters

CalculatedMembersInFilters

ColumnGrand

CompactRowIndent

DisplayContextTooltips

DisplayEmptyColumn

DisplayEmptyRow

DisplayErrorString

DisplayFieldCaptions

DisplayImmediateItems

DisplayMemberPropertyTooltips

DisplayNullString

EnableDrilldown

EnableWriteback

ErrorString

FieldListSortAscending

HasAutoFormat

InGridDropZones

LayoutBlankLine

MergeLabels

NullString

PageFieldOrder

PageFieldWrapCount

Parent

PreserveFormatting

PrintDrillIndicators

PrintTitles

RefreshOnFileOpen

RepeatAllLabels

RepeatItemsOnEachPrintedPage

RowAxisLayout

RowGrand

SaveData

ShowDrillIndicators

ShowValuesRow

SortUsingCustomLists

SubtotalHiddenPageItems

SubtotalLocation

Subtotals

TotalsAnnotation

ViewCalculatedMembers

VisualTotals

VisualTotalsForSets

xlMissingItemsNone