Question: do pivot tables auto update?
Answer: And you can set your workbook to refresh its PivotTable data automatically when you open it. 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.