Refresh

Updates the pivot table.

After you import an Excel spreadsheet that contains a pivot table, click in the table, and then choose Data - Pivot Table - Refresh.

To access this command...

Choose Data - Pivot Table - Refresh.