In excel workbook, one can set a data extraction to auto refresh when the workbook is opened.
Can we have the same feature for pivot tables, to auto refresh on workbook open.