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:
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:
•On the Toolbar, select the Pivot Table section and click the (Refresh) button.
•Right-click the context menu and select Refresh Pivot Table.
•If the pivot table was created in a third-party application, on the pivot table configuration panel, click Update which appears below the "The source data has changed. Please update to load the latest data." 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 fields and elements is not supported.