Updating data

Once inserted in a spreadsheet, your data is kept up-to-date, reflecting any changes made to your database. Reopening the spreadsheet reloads the linked data.

注解

To update pivots and lists data without reopening a spreadsheet, go to the menu bar and click Data ‣ Refresh all data.

Pivot data

Using Refresh all data only updates existing pivot cells. If new cells need to be added, go to the menu bar and click Data ‣ Re-insert pivot to fully update the pivot. Alternatively, click Insert pivot, select the pivot, and tick Display missing cells only to preview first the missing data.

Displaying missing cells in a pivot

To change which records are used by the pivot, right-click on a pivot cell, select See pivot properties, and click Edit domain.