PivotCache.Refresh() Method
Refreshes the PivotTable cache to get the latest data from the data source.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v19.1.Core.dll
Declaration
Remarks
Use the Refresh method to refresh a specific pivot cache in the document after the source data has been changed to make sure that the latest data appears in your report.
// Access the pivot table by its name in the collection.
PivotTable pivotTable = worksheet.PivotTables["PivotTable1"];
// Refresh the pivot table.
pivotTable.Cache.Refresh();
Note that when you refresh one pivot table, all the pivot tables that are based on the same cache will also be refreshed.
To refresh all PivotTable caches in a workbook at once, use the PivotCacheCollection.RefreshAll method.
Related GitHub Examples
The following code snippets (auto-collected from DevExpress Examples) contain references to the Refresh() method.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.