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
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.
You can locate the source data by using the PivotTable and PivotChart ...