Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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