Change Data Source in Pivot Table

Exercise Workbook:

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

STEP 1: Let us check out the current data source. Go to PivotTable Analyze > Data > 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!

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.

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

Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.