Pivot Table- how to pick up new rows

New Contributor

Why doesn't pivot table pick up new rows added to the excel spreadsheet?

1 Reply

@cda23 You need to expand the data source or use one that automatically expands. The latter would be a structured table. Let's say you give that table a name like tblPivotData, then you set the data source to tblPivotData. When you then add rows directly below that table it will expand as will the source for the pivot table. Press refresh and the pivot will update.