Question: can pivot table auto refresh?
Answer: Refresh PivotTable data. At any time, you can click Refresh to update the data for the PivotTables in your workbook. ... By default, PivotTables are not refreshed automatically, but you can specify that the PivotTable is automatically refreshed when you open the workbook that contains the PivotTable.