How can we help you?

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.

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

Was this helpful?
Yes
No
Previous
Collapse or expand the elements of pivot table
Next
Delete a pivot table