Add New Source Rows to an Existing PivotTable in WPS Spreadsheets on Mac
Question details
The user needs to include newly entered rows in an existing PivotTable on Mac without rebuilding the PivotTable or dependent worksheets.
- Product
- WPS Office Spreadsheets / Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user has an existing PivotTable based on a fixed source range and wants new source rows to be reflected automatically.
- Observed behavior
- Newly added rows do not appear after refreshing because the PivotTable source range does not expand automatically.
Make sure your source data has a header row with unique column names and no completely blank rows or columns inside the range before you convert it to a table.
Convert the source range to a table and point the PivotTable to it
Best for users who regularly add new rows and want them included automatically without rebuilding the PivotTable.
A table expands automatically when you add rows directly below it. Changing the PivotTable source to that table means each refresh picks up the new records.
Open your workbook in WPS Spreadsheets on Mac and click any cell inside the data range that feeds the PivotTable.
Go to the Insert tab and click Table. Confirm the range and check "My table has headers," then click OK.
Click inside the existing PivotTable, open the PivotTable Tools tab, and choose Change Data Source. Select the table you just created or type its name, then click OK.
Add new records directly below the table, click inside the PivotTable, and click Refresh on the PivotTable Tools tab to display the new rows.
Manually update the PivotTable data source range
Use this when you only need a one-time fix and prefer not to convert the source range to a table.
Add New Rows to an Existing PivotTable with WPS Spreadsheets
WPS Office Spreadsheets lets you convert a fixed source range into a table, connect it to an existing PivotTable, and refresh it so newly added rows appear automatically on Mac.
- 1. Open the Excel file in WPS Spreadsheets: Launch WPS Office on your Mac and open the workbook that contains the PivotTable and source data.
- 2. Convert the data range to a table: Click inside the source range, go to Insert > Table, confirm the range and header option, and click OK.
- 3. Connect the PivotTable to the table: Click inside the PivotTable, open PivotTable Tools > Change Data Source, select the table, and click OK.
- 4. Refresh after adding new rows: Add new rows directly below the table, click inside the PivotTable, and click Refresh to update the report.
Frequently Asked Questions
Why do new rows not show up in my existing PivotTable on Mac?
The PivotTable is likely using a fixed source range. Convert the source data to a table or manually update the data source range, then refresh the PivotTable.
Do I need to rebuild the PivotTable after converting the source range to a table?
No. Click inside the PivotTable, go to PivotTable Tools > Change Data Source, select the table, and click OK. Then refresh.
Will rows added below the table appear automatically?
Yes. Rows entered directly below a table become part of the table. After adding them, click Refresh in the PivotTable Tools tab to update the report.
Can I use this method in WPS Spreadsheets on macOS?
Yes. WPS Spreadsheets supports tables, PivotTable data source changes, and refresh on macOS, and it works with Excel file formats.
What should I check before converting my range to a table?
Make sure the range has a header row with unique column names and no completely blank rows or columns inside the data.
