Courses / PivotTables & PivotCharts
2. Using an Excel Table as Pivot source
Why and how to convert data to an Excel Table so the PivotTable updates automatically when rows are added.
PivotTables and PivotCharts: building, grouping, calculated fields and presenting insights
Using an Excel Table as Pivot source
An Excel Table is a special, auto-expanding range you can point a PivotTable at so the pivot can include new rows without you editing its source range.
"I keep adding rows and wonder why my PivotTable doesn't include the new data."
Convert your raw data range to an Excel Table (Ctrl+T) and use the Table name as the PivotTable source so you don't have to manually resize the source when you add rows.
"I keep adding rows and wonder why my PivotTable doesn't include the new data."
Convert your raw data range to an Excel Table (Ctrl+T) and use the Table name as the PivotTable source so you don't have to manually resize the source when you add rows.