A pivot table needs to be refreshed in the following cases:
•When working with the document in the source table and the data on the basis of which the pivot table was created has changed.
•When you open a document created using third-party editors which contains a pivot table in MyOffice Spreadsheet.
To refresh a pivot table, follow these steps:
1.Select the entire range or one or multiple cells of the pivot table range.
2.Update the pivot table in one of the following ways:
•In the Command menu, select and click .
•On the Toolbar, select the section and click .
•Right-click the context menu and select .
•If the pivot table was created in a third-party application, in the pivot table configuration pane, click which appears below the “.” message.
•Collapsing and expanding the pivot table levels is not supported. When you update a table, all collapsed levels are automatically expanded.
•The use of calculated elements is not supported.