Excel Pivot Table: How To Change Data Source

This video will show you how to change the data range in a Pivot Table in Excel. If you need to know how to how to expand range in an Excel Pivot Table this is the video for you. This video will show you step by step how to update data range in a pivot table.

After you create a table you might want to change the range of its source data. Depending on the type of change in the Source Data used for Pivot Table, you may find the need to either Change Pivot Table Data Source or simply Change Pivot Table Range.

Firstly, you have to know how to find your source data for your table like I showed in a previous video.

Link here 👇

All you need to do now is expand your table by removing the existing data source, and type in a new table name, or select a new data source range.

If you find this useful, please drop a 👍 on the video and subscribe 🧐

Timestamp:
00:00 How we do this?🤔
00:25 Find Data Source
00:45 Change Data Source
01:12 This is how you do it!

🔴 RECOMMENDED VIDEOS/PLAYLISTS

Feeling generous? I like coffee.🤗

[cogwheelLearning]

Need help with Pivot Tables? 😰
✅I created a playlist with all the tips & tricks you'll need to master them:

[cricketerfahad]

Thank you so much it really helps me ❤

[HelpMe-ouik]

Hello, I would like to split a document by destination (for example) and create automatically various specific files (for each destination) with the relevant pivot chart. How to do to update the data source of the new pivot charts each time (Spain, Italy, France...) ? As they keep the original data source with all destinations (Europe). Thanks

Dim pt As PivotTable
Dim MyData As Excel.ListObject

Set MyData =

For Each pt In - City").PivotTables
pt.ChangePivotCache _
(SourceType:=xlDatabase, SourceData:="MyData")
Next pt