Jun 26 2022 05:38 PM
Why doesn't pivot table pick up new rows added to the excel spreadsheet?
Jun 26 2022 10:48 PM
@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.