Name
pivottable
.PivotTableWizard([SourceType
], [SourceData
], [TableDestination
], [TableName
], [RowGrand
], [ColumnGrand
], [SaveData
], [HasAutoFormat
], [AutoPage
], [Reserved
], [BackgroundQuery
], [OptimizeCache
], [PageFieldOrder
], [PageFieldWrapCount
], [ReadData
], [Connection
])
Synopsis
Quickly creates a pivot table and returns a reference to the created PivotTable
object.
Argument |
Settings |
---|---|
|
An |
|
If |
|
The |
|
A name to assign to the pivot table. Default is |
|
True displays grand totals for rows; False omits row totals. Default is True. |
|
True displays grand totals for columns; False omits column totals. Default is True. |
|
If |
|
True automatically adjusts column widths when the pivot table is refreshed; False preserves column widths ... |
Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.