Pinterest Pixel

Change Data Source in Pivot Table

After you have finished setting up your Pivot Table, it is very easy to change the data... read more

Download Excel Workbook
Bryan
Posted on

Overview

Change Data Source in Pivot Table | MyExcelOnline Change Data Source in Pivot Table | MyExcelOnline

After you have finished setting up your Pivot Table, it is very easy to change the data source in case you made a mistake or just need to change it. Let me show you how to do it in a couple of steps!

 

Exercise Workbook:

download excel workbookChange-Data-Source.xlsx


Let us go over our current Pivot Table and select any cell inside it:

Change Data Source in Pivot Table

STEP 1: Let us check out the current data source. Go to PivotTable Analyze > Data > Change Data Source

Change Data Source in Pivot Table

STEP 2: You can see that our current setup is incorrect as it covers only a part of a Data Range. Let us fix that!

Change Data Source in Pivot Table

STEP 3: It is better to always use an Excel Table as your data source so that when you update your data it will be always included inside your data source.

Go to the Data_Table worksheet and select the entire data table (you can use the CTRL+A keyboard shortcut to select the table).

See also  Import Data from CSV Using Power Query or Get & Transform

Click OK.

Change Data Source in Pivot Table

And your Pivot Table is now reflecting the new data source!

Change Data Source in Pivot Table

 

If you like this Excel tip, please share it
Change Data Source in Pivot Table | MyExcelOnline Change Data Source in Pivot Table | MyExcelOnline
Change Data Source in Pivot Table | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...