Forum Discussion
dmalmgre
Jul 01, 2023Copper Contributor
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 ev...
Riny_van_Eekelen
Jul 01, 2023Platinum Contributor
dmalmgre Pivot tables work the same on Mac and PC. How did you set up the source data for the PT?
dmalmgre
Jul 01, 2023Copper 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.