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
Change Data Source in Pivot Table

Overview

Change Data Source in Pivot Table

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

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  Excel Group by Week Starting on a Monday With Excel Pivot Tables

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 itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

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!