Microsoft Office Tutorials and References
In Depth Information
Table 20-2. Members of the PivotTable Object
The members of the PivotTable object are shown in Table 20-2 . We'll discuss the most important
of these members by their function.
Table 0-2. Members of the Piv otTable Object
_Default
ErrorString
PrintTitles<v9>
_PivotSelect<v10>
Format<v9>
RefreshDate
AddDataField<v10>
GetData
RefreshName
AddFields
GetPivotData<v10>
RefreshTable
Application
GrandTotalName<v9>
RepeatItemsOnEachPrintedPage<v9>
CacheIndex
HasAutoFormat
RowFields
CalculatedFields
HiddenFields
RowGrand
CalculatedMembers<v10>
InnerDetail
RowRange
ColumnFields
ListFormulas
SaveData
ColumnGrand
ManualUpdate
SelectionMode
ColumnRange
MDX<v10>
ShowCellBackgroundFromOLAP<v10>
CreateCubeFile<v10>
MergeLabels
ShowPageMultipleItemLabel<v10>
Creator
Name
ShowPages
CubeFields<v9>
NullString
SmallGrid<v9>
DataBodyRange
PageFieldOrder
SourceData
DataFields
PageFields
SubtotalHiddenPageItems
DataLabelRange
PageFieldStyle
TableRange1
DataPivotField<v10>
PageFieldWrapCount
TableRange2
DisplayEmptyColumn<v10>
PageRange
TableStyle
DisplayEmptyRow<v10>
PageRangeCells
Tag
DisplayErrorString
Parent
TotalsAnnotation<v9>
DisplayImmediateItems<v10> PivotCache
Update
DisplayNullString
PivotFields
VacatedStyle
Dummy15<v10>
PivotFormulas
Value
EnableDataValueEditing<v10> PivotSelect
Version<v10>
EnableDrilldown
PivotSelection
ViewCalculatedMembers<v10>
EnableFieldDialog
PivotSelectionStandard<v10> VisibleFields
EnableFieldList<v10>
PivotTableWizard
VisualTotals<v10>
EnableWizard
PreserveFormatting
20.5.1 Returning a Fields Collection
Several of the members of the PivotTable object are designed to return a fields collection.
20.5.1.1 ColumnFields property
This property returns the collection of all column fields, using the syntax:
PivotTableObject .ColumnFields
Alternatively, we can return selected column fields using the syntax:
PivotTableObject .ColumnFields( Index )
 
Search JabSto ::




Custom Search