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 WORKBOOK


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

Change Data Source in Pivot Table | MyExcelOnline

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

change data source

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 | MyExcelOnline

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

Click OK.

Change Data Source in Pivot Table | MyExcelOnline

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

Change Data Source in Pivot Table | MyExcelOnline

 

HELPFUL RESOURCE:

Make sure to download our FREE PDF on the 101 Best Excel Tips & Tricks:

Change Data Source in Pivot Table | MyExcelOnline

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn