## WorksheetCollection::RefreshPivotTables() method


Refreshes all the PivotTables in the Excel file.

```cpp
void Aspose::Cells::WorksheetCollection::RefreshPivotTables()
```

## See Also

* Class [Vector](../../vector/)
* Class [WorksheetCollection](../)
* Namespace [Aspose::Cells](../../)
* Library [Aspose.Cells for C++](../../../)
## WorksheetCollection::RefreshPivotTables(const PivotTableRefreshOption\&) method


Refreshes all the PivotTables in the Excel file.

```cpp
bool Aspose::Cells::WorksheetCollection::RefreshPivotTables(const PivotTableRefreshOption &option)
```


| Parameter | Type | Description |
| --- | --- | --- |
| option | const PivotTableRefreshOption\& | The option for refreshing data source of the pivot tables. |

## See Also

* Class [Vector](../../vector/)
* Class [PivotTableRefreshOption](../../../aspose.cells.pivot/pivottablerefreshoption/)
* Class [WorksheetCollection](../)
* Namespace [Aspose::Cells](../../)
* Library [Aspose.Cells for C++](../../../)