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 (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.”

If you have formatted the cells in the pivot table (changed the font, text color, highlights, and so on), the formatting will remain the same after the refresh, except for the following:

•The source data of the field added to the Columns area has been changed. In this case, the formatting of the cells in this field, as well as the cells in the child fields, will be reset.

•The source data of the field added to the Rows area has been changed. In this case, the formatting of the cells in this field, as well as the cells in the child fields, will be reset.