Download Using VBA to Create Pivot Tables

12_0789736012_CH11.qxd
238
Chapter 11
12/11/06
6:26 PM
Page 238
Using VBA to Create Pivot Tables
Table 11.2 Continued
Property
Description
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 column 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 proerty 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.
11