tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

MS Excel: Change data source for a pivot table in Excel 2010

See solution in other versions of Excel:

Question: In Microsoft Excel 2010, I've created a pivot table and now I need to change the data source. How do I change the data source for an existing pivot table?

Answer:Select the Options tab from the toolbar at the top of the screen. In the Data group, click on Change Data Source button.

Microsoft Excel

When the Change PivotTable Data Source window appears, change the Table/Range value to reflect the new data source for your pivot table. Click on the OK button.

Microsoft Excel

Now when you return to your pivot table, it should display information from the new data source.

Microsoft Excel