Excel: Automatically refresh pivot table when file is opened
Question: How do I get a pivot table to automatically refresh when the Excel spreadsheet is opened? Answer: Select a cell in the pivot table. Right-click and then select "Table Options" from the popup menu.
|
When the PivotTable Options window appears, check the checkbox called "Refresh on open". Click on the OK button.
|
