Aspose::Cells::Pivot::PivotCache::Refresh method

PivotCache::Refresh(const PivotTableRefreshOption&) method

Refreshes data from the data source and calculates data for the view of all pivottables which data source is this pivot cache.

PivotRefreshState Aspose::Cells::Pivot::PivotCache::Refresh(const PivotTableRefreshOption &option)
ParameterTypeDescription
optionconst PivotTableRefreshOption&The options for refreshing data source of pivot table.

Remarks

It’s better that you can simply call Workbook.RefreshAll() to refresh all pivot tables and charts in the file.

See Also

PivotCache::Refresh() method

Refreshes data from the data source and calculates data for the view of all pivottables which data source is this pivot cache.

PivotRefreshState Aspose::Cells::Pivot::PivotCache::Refresh()

Remarks

If both table1 and table2 use this cache, the two table will calculated. It’s better that you can simply call Workbook.RefreshAll() to refresh all pivot tables and charts in the file.

See Also