• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Updating a Pivot Table

The pivot table display does not change when you change the data in the source list or table. You can update, or refresh, the pivot table for the following types of changes to the source data by selecting any cell within the pivot table and clicking the Refresh Data button on the PivotTable toolbar:

  • Changes to data in a data field

  • New or changed items

  • Insertions or deletions of fields or items


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint