How to Update PivotTable Automaticallyby Suvro Banerji
PivotTable is an interactive, cross-tabulated Microsoft Office Excel feature that produces reports to analyze data (e.g., database records) from various sources, including the ones that are outside of Microsoft Office applications. Using PivotTable, you can automatically update a data source by changing the cell reference. This makes it possible for you to update data automatically without having to change the format of the report or database.
Click the Start menu and launch "Microsoft Office Excel."
Open the report with the PivotTable you wish to update.
Single-click the cell within the PivotTable that you wish to update.
Click the "Tools" menu and choose "PivotTable and PivotChart Wizard." This will automatically run the PivotTable wizard.
Type the new cell reference that you wish to update to in the box labeled "Source Data." Click "Next." Click "Finish" to finish the automatic update.