PivotCache.Refresh

Refresh(PivotTableRefreshOption)

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

public PivotRefreshState Refresh(PivotTableRefreshOption option)

Parameter	Type	Description
option	PivotTableRefreshOption	The options for refreshing data source of pivot table.

Remarks

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

See Also

• enum PivotRefreshState
• class PivotTableRefreshOption
• class PivotCache
• namespace Aspose.Cells.Pivot
• assembly Aspose.Cells

---

Refresh()

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

public PivotRefreshState Refresh()

Remarks

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

See Also

• enum PivotRefreshState
• class PivotCache
• namespace Aspose.Cells.Pivot
• assembly Aspose.Cells