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 data, existing records are modified, or the source data file 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.

To reproduce the environment in which they were created, sample files must be stored in a C:\_Work folder, for testing. If a different folder is used, the connections will be broken. Create this folder on your computer's C: drive, and then copy all the sample files to it. Depending on your security settings, you may see a security warning when opening some sample files. To work with the ...

Get Excel 2007 PivotTables Recipes: 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.