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

Copper Contributor

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.

2 Replies

@dmalmgre Pivot tables work the same on Mac and PC. How did you set up the source data for the PT?

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.