PivotTable Methods
Represents a PivotTable report on a worksheet.| Name | Description |
|---|---|
| BeginUpdate() | Locks the PivotTable object by preventing visual updates until the EndUpdate method is called. |
| ChangeDataSource(PivotCache) | Changes the data source for the PivotTable report. |
| ChangeDataSource(Range) | 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 a call to the BeginUpdate method and causes an immediate visual update. |
| MoveTo(Range) | Moves a pivot table to the specified location. |
See Also