[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Collapse]Spreadsheet Document API
   Product Structure
   Getting Started
  [Expand]Spreadsheet Document
   Supported Formats
  [Expand]Cell Basics
   Defined Names
   Data Binding
  [Expand]Pivot Tables
  [Expand]Charts and Graphics
  [Expand]Mail Merge
   [Expand]Rows and Columns
   [Expand]Import and Export Data
   [Expand]Data Binding
   [Expand]Mail Merge
   [Expand]Formatting Cells
   [Expand]Conditional Formatting
   [Expand]Group Data
   [Expand]Filter Data
   [Collapse]Pivot Tables
     How to: Create a Pivot Table
     How to: Refresh a Pivot Table
     How to: Change a Data Source for a Pivot Table
     How to: Move a Pivot Table
     How to: Clear or Remove a Pivot Table
     How to: Change the PivotTable Layout
     How to: Subtotal Fields in a Pivot Table
     How to: Display or Hide Grand Totals for a Pivot Table
     How to: Format Numbers and Dates in a Pivot Table
     How to: Apply a Predefined Style to a Pivot Table
     How to: Apply a Custom Style to a Pivot Table
     How to: Control Style Options
     How to: Change the Summary Function for a Data Field
     How to: Apply a Custom Calculation to a Data Field
     How to: Create a Calculated Field
     How to: Create a Calculated Item
     How to: Sort Items in a Pivot Table
     How to: Filter Items in a Pivot Table
     How to: Group Items in a Pivot Table
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Expand]Excel Export Library
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Expand]API Reference
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

How to: Clear or Remove a Pivot Table

The examples below demonstrate how to clear a pivot table by removing all its fields or completely delete a report from a worksheet.

Select the task you wish to perform.

Expanded Clear a Pivot Table

To remove all fields and formatting from a PivotTable report, use the PivotTable.Clear method. This method resets the pivot table to the initial state before any fields are added to it, but does not delete the report. The data connection, PivotCache, and the report location are preserved.


If a pivot table you wish to clear is based on the same data as other pivot tables in a document, the PivotTable.Clear method will also remove grouping, calculated fields, and calculated items from other shared PivotTable reports.

The following image shows the result of the code's execution (the workbook is opened in Microsoft® Excel®). A blank pivot table is displayed so you can start designing the report's layout all over again.

Expanded Delete a Pivot Table

To delete a PivotTable report from a worksheet, remove it from the worksheet's PivotTableCollection by using the PivotTableCollection.Remove or PivotTableCollection.RemoveAt method.

Is this topic helpful?​​​​​​​