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.

Refreshing and updating PivotTables

Refreshing and updating PivotTables - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Refreshing and updating PivotTables

“

- [Narrator] So when you're working with pivot tables, you'll be taking one of two general approaches when it comes to your source data. That source data will either be static or dynamic. And what I mean by that, is that sometimes you'll have just one set of data that will never ever change that you'll want to use a pivot table tool to analyze. When that's the case, we'll call that static source data. What's more common is having source data that you may need to edit or tweak or add data to moving forward that you'll want to attach a pivot table to. And in that case, your source data is dynamic. And when you're working with dynamic data it's important to understand how to refresh and update your pivot table as you make changes to that source data. So there are two tools in the analyze tab called refresh and change data source which allow you to do just that. Now the difference between the two is that refresh will update your pivot table based on changes made within the defined source…

Contents