Automatic change of data source in a pivot table
There is a problem with Pivot Table. When you add new row or column to source table, the pivot table won’t expand range. You must do it manually using menu “Change Data Source”. So this is the question, how can I do it automatically?
The left table is a source and the right table is a pivot table. We want to add another rows or columns to the source and see them in the pivot table. Before that we have to format source table as Table
Click somewhere on the source table. Then go to the menu “Format as Table” and choose one of the styles.