Pivot tables

Hello Katy,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding Pivot Tables and adding more data to the source table which by default doesn't get added to the PivotTable.

There are a few suggestions I can make to help you with this issue.

1) Use the Change Data Source button located on the Options ribbon to change the range to include the rows or columns of new data.

2) Before adding new data, insert new rows within the data range and then add the data. On the Options ribbon click the Refresh button to update the PivotTable.

3) Format the source data range as a Table and then use the bottom right-hand corner of the range to expand both rows or columns. Provide as many rows/columns as required and fill in the data. Refresh the data in the PivotTable as in 2 above.

4) You can also name the source data range and create a dynamic named range. This method is beyond the scope of this forum and can be learned when attending our PivotTable training course which covers one day.



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. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer