Classe DefaultPivotTableLayoutOptions (Excel VBA)

La classe Application donne accès à la classe DefaultPivotTableLayoutOptions

Dim dpts as DefaultPivotTableLayoutOptions
Set dpts = Application.DefaultPivotTableLayoutOptions

Propriétés

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