Back to Devexpress

PivotCacheCollection.RefreshAll() Method

officefileapi-devexpress-dot-spreadsheet-dot-pivotcachecollection.md

latest1.6 KB
Original Source

PivotCacheCollection.RefreshAll() Method

Refreshes all pivot caches in the workbook.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
void RefreshAll()
vb
Sub RefreshAll

Remarks

The RefreshAll property allows you to refresh all pivot tables in the document at once to reflect any changes made in the source data.

If you wish to refresh a specific pivot table in your document, use the PivotTable.Cache property to get the report’s data cache and then call its PivotCache.Refresh method. If the specified pivot cache is shared between two or more PivotTable reports, all these reports will also be updated.

See Also

Cache

Refresh()

PivotCacheCollection Interface

PivotCacheCollection Members

DevExpress.Spreadsheet Namespace