Search notes:

Excel Object Model: PivotField

Properties and methods

AddPageItem()
AllItemsVisible
Application
AutoGroup()
AutoShow()
AutoShowCount
AutoShowField
AutoShowRange
AutoShowType
AutoSort()
AutoSortCustomSubtotal
AutoSortField One of the «interesting» properties
AutoSortOrder One of the «interesting» properties
AutoSortPivotLine
BaseField
BaseItem
CalculatedItems()
Calculation
Caption One of the «interesting» properties
ChildField One of the «interesting» properties
ChildItems
ClearAllFilters()
ClearLabelFilters()
ClearManualFilter()
ClearValueFilters()
Creator
CubeField
CurrentPage
CurrentPageList
CurrentPageName
DatabaseSort
DataRange The range that the data that is represented by a pivot field occupies on a worksheet.
DataType which is assigned one of the values of the xlPivotFieldDataType enumeration: xlNumber, xlText or xlDate.
Delete()
DisplayAsCaption
DisplayAsTooltip
DisplayInReport
DragToColumn
DragToData
DragToHide
DragToPage
DragToRow
DrilledDown
DrillTo()
EnableItemSelection
EnableMultiplePageItems
Formula
Function One of the «interesting» properties
GroupLevel One of the «interesting» properties
Hidden
HiddenItems
HiddenItemsList
IncludeNewItemsInFilter
IsCalculated
IsMemberProperty
LabelRange A range (but it unclear to me what it represents).
LayoutBlankLine
LayoutCompactRow
LayoutForm
LayoutPageBreak
LayoutSubtotalLocation
MemberPropertyCaption
MemoryUsed One of the «interesting» properties
Name One of the «interesting» properties
NumberFormat One of the «interesting» properties
Orientation A member of the xlPivotFieldOrientatinon enumeration: xlColumnField, xlDataField, xlHidden, xlPageField, xlRowField. Fields Within an orientation are ordered according to the value of the field's Position value.
Parent
ParentField
ParentItems
PivotFilters
PivotItems()
Position A number that represents the position within the field's orientation (see als Orientation property)
PropertyOrder
PropertyParentField
RepeatLabels
ServerBased
ShowAllItems
ShowDetail
ShowingInAxis One of the «interesting» properties
SourceCaption
SourceName
StandardFormula
SubtotalName
Subtotals
TotalLevels
UseMemberPropertyAsCaption
Value
VisibleItems
VisibleItemsList

See also

pivotTable
Excel Object Model

Index