AllowMultipleFilters Indicates whether a pivot field can have multiple
filters applied to it at the same time.
CompactLayoutColumnHeader Specifies the caption that is displayed in the col-
umn header of a pivot table when in compact
row layout form.
CompactLayoutRowHeader Specifies the caption that is displayed in the row
header of a pivot table when in compact row
layout form.
CompactRowIndent Indicates the indent increment for pivot items
when compact row layout form is turned on.
DisplayContextTooltips Controls whether ToolTips are displayed for
pivot table cells.
DisplayFieldCaptions Controls whether filter buttons and pivot field
captions for rows and columns are displayed in
the grid.
DisplayMemberPropertyTooltips Controls whether to display member properties
in ToolTips.
FieldListSortAscending Controls the sort order of fields in the
PivotTable Field List. When this property is
True, the fields are sorted in alphabetical order.
When it is set to
False, the fields are presented
in the same sequence as the data source
columns.
InGridDropZones Controls whether you can drag and drop fields
onto the grid. Changing the pivot table layout
also changes this property. Changing this pro-
erty forces the layout back to a table layout.
LayoutRowDefault Specifies the layout settings for pivot fields
when they are added to the pivot table for the
first time. Valid values are
xlCompactRow,
xlTabularRow, or xlOutlineRow.
PivotColumnAxis Returns a PivotAxis object representing the
entire column axis.
PivotRowAxis Returns a PivotAxis object representing the
entire row axis.
PrintDrillIndicators Specifies whether drill indicators are printed
with the pivot table.
Chapter 11 Using VBA to Create Pivot Tables
238
11
Table 11.2 Continued
Property Description
12_0789736012_CH11.qxd 12/11/06 6:26 PM Page 238
To Next Page
Loading...
Need help?
General
