PivotTable Methods
Represents a PivotTable report on a worksheet.
Name | Description |
---|---|
Begin |
Locks the Pivot object. Prevents visual updates until the End method calls.
|
Change |
Changes the data source for the Pivot |
Change |
Changes the data source for the Pivot |
Clear() |
Removes all fields, formatting and report filters from the Pivot |
End |
Unlocks the Pivot object after you call Begin . It also causes an immediate visual update.
|
Move |
Moves a pivot table to the specified location. |
See Also