Refresh a pivot table

A pivot table needs to be refreshed in the following cases:

•When you work with the document, the data on which the pivot table was created has changed in the source table.

•MyOffice Spreadsheet opens a document with a pivot table created in a third-party editor.

•MyOffice Spreadsheet opens a document with a pivot table that contains irrelevant data.

•You need to view the cell details.

To refresh a pivot table, follow these steps:

1.Select the entire range or one/several cells from the range of the pivot table.

2.Refresh the table in one of the following ways:

•In the Data menu, click Refresh Pivot Table.

•On the Toolbar, in the Pivot Table section, click  Refresh Pivot Table.

•Right-click to open the context menu and run the Refresh Pivot Table command.

•If you created the pivot table in a third-party application, in the Pivot Table settings pane, on the Constructor tab, click the Update button, which is displayed below the message: “The source data has changed. Please update to load the latest data.”

•If the pivot table contains irrelevant data, in the Pivot Table settings pane, on the Constructor tab, click the Refresh button, which is displayed below the message: “Data may be outdated. Please refresh the pivot table.”