Refresh Pivot Table:
Whenever we make the changes in raw data, we have to Refresh the pivot table so that changes can be reflected in the pivot table.
To refresh a pivot table select the pivot table and go to Analyze Tab>>Click on Refresh button available in Data group.
Pivot table will be refreshed and changes will be reflected in the pivot table immediately.
![Refresh Pivot table](https://www.pk-anexcelexpert.com/wp-content/uploads/PivotTables/Pivot-Table-50.jpg)
Change Data Source:
To change the Data Source of a pivot table follow below steps:
- Click any where in the pivot table
- Go to Analyze Tab>>Click on Change Data Source available in Data Group
![Change Data Source Option](https://www.pk-anexcelexpert.com/wp-content/uploads/PivotTables/Pivot-Table-51.jpg)
Change Pivot Table Data Source window will be displayed. Change range in this window and click on OK. Pivot range will be changed.
![Change Pivot Table Data Source window](https://www.pk-anexcelexpert.com/wp-content/uploads/PivotTables/Pivot-Table-52.jpg)