Updating source data for pivot table

Sometimes, you may get a dataset that is unsuitable to be used as the source data for Pivot Table.

In such a case, you may have no choice but to convert the data into a Pivot friendly data format.

The written instructions are below the video, and you can download the sample file to follow along with the video.

updating source data for pivot table-60updating source data for pivot table-81updating source data for pivot table-37updating source data for pivot table-41

So, the point is we have to use a method to update source range automatically when you add new data. So today, in this post, I will tell you three different methods which you can use to update pivot pivot table range automatically. Tip: change your data set to a table before you insert a pivot table. On the Analyze tab, in the Data group, click Change Data Source.Having the data in the right format is a crucial step in creating a robust and error-free Pivot Table.If not done the right way, you can end up having a lot of issues with your pivot table.

Leave a Reply