Skip to main content
Row

PivotCache.Refresh() Method

Refreshes the PivotTable cache to get the latest data from the data source.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

void Refresh()

Remarks

Use the Refresh method to refresh a pivot table after the source data was changed to ensure that the latest data appears in your report.

// Access the pivot table in the collection.
PivotTable pivotTable = worksheet.PivotTables["PivotTable1"];
// Refresh the pivot table.
pivotTable.Cache.Refresh();

When you refresh a pivot table, all the pivot tables that are based on the same cache are also refreshed.

Call the PivotCacheCollection.RefreshAll method to refresh all PivotTable caches in a workbook.

Use the following properties to determine who and when refreshed a pivot table last time:

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.

See Also