Updates the DataPilot table.
After you import an Excel spreadsheet that contains a PivotTable, click in the table, and then choose Data - DataPilot - Refresh Data.
To access this command...
Choose Data - DataPilot - Refresh Data