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