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

@Giuseppe_Abbatantuono 

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

HansVogelaar_0-1689864350246.png

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