.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

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