There are two main ways to refresh a PivotTable to reflect changes in its source data:

1. Manual Refresh:

* Click anywhere within the PivotTable to activate it.
* Go to the Analyze tab on the Excel ribbon.
* In the Data group, click the Refresh button.

Keyboard Shortcut: Alternatively, you can press Alt+F5 to refresh the PivotTable.

2. Refresh Options (For Automatic Updates):

* Click anywhere within the PivotTable to activate it.
* Go to the Analyze tab on the Excel ribbon.
* In the Data group, click the Change Data Source button.
* A dialog box will appear.
* Select the Refresh data when opening the file checkbox if you want the PivotTable to update automatically whenever you open the workbook.

Additional Tips:

* If your source data is on a different sheet or workbook, ensure those files are accessible when refreshing the PivotTable.
* For large datasets, refreshing the PivotTable might take a few seconds.
* Consider formatting your source data as an Excel Table for easier data management and automatic PivotTable updates.