At any time, you can select Refresh to update the data for the PivotTables in your workbook. You can refresh the data for PivotTables imported from Power Query, such as a database (SQL Server, Oracle, Access, and so on), Analysis Services cube, a data feed, and many other sources.

To update all PivotTables in your workbook at once, on the PivotTable Analyze tab, select the Refresh arrow and choose Refresh All. Select Auto Refresh in the Data group to turn it on or off. Auto Refresh is on if the button has an outline around it.

To control when updates occur, you can refresh the PivotTable manually from the PivotTable Analyze tab or configure refresh settings in PivotTable Options. You can also temporarily suspend updates by setting Excel to manual calculation mode.

In Power Pivot, click Home > Get External Data > Refresh or Refresh All to re-import the current table or all of the tables in the data model. Status of the refresh is indicated for each connection used in the data model.

After you create a PivotTable, you can change the range of its source data. For example, you can expand the source data to include more rows of data. However, if the source data has been changed substantially—such as having more or fewer columns, consider creating a new PivotTable.

Refresh atau perbarui data dalam PivotTable yang tersambung ke sumber data eksternal secara manual guna melihat perubahan yang dibuat terhadap data itu, atau melakukan refresh secara otomatis ketika membuka buku kerja.

When you are working with data in Power Pivot, from time to time you might need to refresh the data from the source, recalculate the formulas that you have created in calculated columns, or make sure data presented in a PivotTable is up-to date.

In the PivotTable Analyze tab, in the Data group, select Refresh. For more information about working with the PivotTable Field List, go to Use the Field List to arrange fields in a PivotTable.

To refresh a specific PivotTable connected to a query, select a cell in the PivotTable, and then select Data > Refresh. When you refresh a query, if authentication is needed, you can select the relevant method – anonymous, user and password, or your organizational account.

How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.