Data pilot tables are summaries of detail data that exists somewhere else in the spreadsheet. If the underlying data upon which the datapilot is based changes, you'll usually want to refresh the data pilot tables. Otherwise the data pilot tables won’t reflect the changes that were made to the underlying data.

To refresh a data pilot table, click on a cell, select the data pilot option from the data menu, then select refresh.