Refresh a pivot table

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

–While working with the document, the data in the source range or external source on which the pivot table was based has changed.

–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:

•On the Home tab, in the Pivot table group, click  Refresh pivot table.

•Right-click to open the context menu and run the Refresh pivot table command.

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.