How do I update the data source in a pivot table, so that it looks in rows/columns that gave been added to the source table after pivot table has been created.

Hello Diana,
I hope you enjoyed your Excel training session with us.

In response to your question, whenever you use pivot tables in Excel, they will not automatically update when you have updated the source data. To update your pivot table, you need to first ensure than any additional rows you have added to your data are included in the dataset used in the pivot table. Click on your pivot table, then choose the menu option Data > PivotTable and PivotChart Report. In the dialog box, ensure you are at step 2 of 3 (you may need to click "back"), and then double check that the range includes all cells in your dataset. If you make a change to the data in your range, but have not actually added any new rows, simply click the icon that looks like a red exclamation mark on the Pivot Table toolbar. This updates the pivot table from the dataset.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer