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 is a best-selling book author of the 101 Excel Series paperback books.