Beginning Pivot Tables in Excel 2007

CHAPTER 8Updating a Pivot Table

In this chapter, you'll learn how to maintain a pivot table after you've created it to ensure that it shows the correct data and stores the data in the way that works best for you. For example:

• If your pivot table is based on an Excel table, what will happen if someone edits the sales data or adds new records? How will you ensure that your pivot table is updated and shows the correct results?
• If a product name is changed in all the records in the database, do you want to see the old name in the pivot table's filter drop-down lists, or should the old name be removed?
• If your pivot table is based on a query in a Microsoft Access database, how can you make it easy to get the updated data into your pivot table throughout ...