officefileapi-devexpress-dot-spreadsheet-dot-pivotcache-da090ef0.md
Refreshes the PivotTable cache to get the latest data from the data source.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
void Refresh()
Sub Refresh
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();
' Access the pivot table in the collection.
Dim pivotTable As 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.
// Refresh the pivot table.
worksheet.PivotTables["PivotTable1"].Cache.Refresh();
// Refresh the pivot table.
worksheet.PivotTables["PivotTable1"].Cache.Refresh();
// Refresh the pivot table.
worksheet.PivotTables["PivotTable1"].Cache.Refresh();
' Refresh the pivot table.
worksheet.PivotTables("PivotTable1").Cache.Refresh()
' Refresh the pivot table.
worksheet.PivotTables("PivotTable1").Cache.Refresh()
' Refresh the pivot table.
worksheet.PivotTables("PivotTable1").Cache.Refresh()
#End Region ' #ChangeLocation
See Also