Automatic refresh of pivot tabel

Copper Contributor

Hi, I need support about the use of the Pivot tables.

How I can set the automatic refresh of the Pivot table.

Thank's you.

1 Reply


You can set a pivot table to be refreshed automatically when the workbook opens, in the Data tab of the PivotTable Options dialog:


For other options, see Excel Pivot Table Refresh Steps and Fixes