Forum Discussion

dmalmgre's avatar
dmalmgre
Copper Contributor
Jul 01, 2023

Adding new rows of data to an existing pivot table in Excel for Mac

I cannot find a way in Excel on a Mac to add new rows of data to an existing pivot table. I'm using the pivot to populate other tables/worksheets, so I don't want to have to start over and rebuild everything. Thanks.

    • dmalmgre's avatar
      dmalmgre
      Copper Contributor
      I found the issue. In order to add the rows, I had to add Month column as a filter and select the new month. Once I added the month and refreshed the pivot table, it brought in all of the data from the rows I added. Thanks.

Resources