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 everything. Thanks.
- Riny_van_EekelenPlatinum Contributor
dmalmgre Pivot tables work the same on Mac and PC. How did you set up the source data for the PT?
- dmalmgreCopper ContributorI 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.