Contents hide
In this post, we will discuss changing the data source or locating the data source for a given Pivot Table. This is extremely helpful when your data keeps on changing constantly.
You can use the below steps:
- First, click anywhere on the pivot table to activate the analyze tab.
- After this, go to Analyze Tab
- Here you need to click on the “Change Data Source” option under Data.
- Now you will get a dialogue box “Change PivotTable Data Source” as below.
- Here in this example, the data range for the PivotTable is Sheet1!$A$1:$F$8 which means that the rows A9 till A13 are not included in the PivotTable.
- Now either select the complete data i.e. Sheet1!$A$1:$F$13 or use the table name range to update your PivotTable/data source.
- In the end, click ok to update the data source.
Apart from this, you can also use the shortcut key Alt ⇢ J ⇢ T ⇢ I ⇢ D to open the “Change PivotTable Data Source” dialog box directly.
Always convert the source data into an Excel Table by pressing the keyboard shortcut Ctrl + T.
By doing this, there will be no need to update your data source again and again. Just refreshing the Pivot Table will update the data range.
More Pivot Table Tutorials
- Add or Remove Grand Total in a Pivot Table
- Add Running Total in a Pivot Table
- Automatically Update a Pivot Table
- Formulas in a Pivot Table (Calculated Field & Item)
- Count Unique Values in a Pivot Table in Excel
- Delete a Pivot Table in Excel
- Filter a Pivot Table in Excel
- Add Ranks in Pivot Table in Excel
- Apply Conditional Formatting to a Pivot Table in Excel
- Pivot Table using Multiple Files in Excel
- Group Dates in a Pivot in Excel
- Group Dates in a Pivot in Excel
- Connect a Single Slicer with Multiple Pivot Tables in Excel
- Move a Pivot Table in Excel
- Pivot Table Formatting in Excel
- Pivot Table Keyboard Shortcuts
- Pivot Table Timeline in Excel
- Refresh a Pivot Table in Excel
- Refresh All Pivot Tables at Once in Excel
- Sort a Pivot Table in Excel
- Pivot Table from Multiple Worksheets in Excel
- Pivot Chart in Excel
⇠ Back to Pivot Table Tutorial