O'Reilly logo

Excel Pivot Tables Recipe Book: A Problem-Solution Approach by Debra Dalgleish

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 7Updating a Pivot Table

Most pivot tables are based on source data that continues to change; new records or fields may be added to the source, existing records are modified, or the source data is moved to a new location. You want to ensure that your pivot table contains the latest available data, and is correctly connected to the source data.

7.1. Using Source Data: Locating and Changing the Source Excel List

Problem

You've been asked to make some changes to a workbook that contains a pivot table, and you'd like to find the Excel list that was used as the source data. Records have been added to the Excel list, and you want to include them in the pivot table.

Solution

You can locate the source data by using the PivotTable and PivotChart ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required