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.
Using Refresh all data only updates existing pivot cells. If new cells need to be added, go to the menu bar and click to fully update the pivot. Alternatively, click Insert pivot, select the pivot, and tick Display missing cells only to preview first the missing data.
To change which records are used by the pivot, right-click on a pivot cell, select See pivot properties, and click Edit domain.