How to Update PivotTable Automatically

by 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.

About the Author

Suvro Banerji is a recent graduate of the Missouri School of Journalism where he earned a dual degree in broadcast news and political science. He began writing professionally in 2005 at KOMU-8 News (NBC) where he worked as a multimedia producer. Banerji has also interned with CNN for two consecutive years.