From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Pro tip: Growing source data

Pro tip: Growing source data - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Pro tip: Growing source data

“

- [Instructor] In the last lecture, we talked about some of the more basic refresh and data source options, but now I want to share two pro tips that are really, really helpful when you're working with dynamic or growing source data. So back in our IMDb Movie Database file, you'll remember that the last tip that I showed you was to simply stack or append new data into rows beneath the existing range. In this case, we added a fake title called Sample Title in row 3727, and from there, we had to go back into the Pivot, Pivot Table Tools, and change the data source manually to capture that new data. But the fact is, there are more efficient ways to accomplish this same task. The first option is to remove the row numbers from our source reference, which will essentially tell Excel to pull in any rows from within those columns so that you can simply refresh rather than adjusting that reference each time. And so, in our Tools, I'm going to go into Change Data Source. And all I'm going to do…

Contents