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 ...

Get Excel Pivot Tables Recipe Book: A Problem-Solution Approach now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.