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(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 a call to the BeginUpdate method and causes an immediate visual update. |
MoveTo(CellRange) | Moves a pivot table to the specified location. |
See Also