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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
