Add 2024 Records to an Excel PivotTable or PivotChart on Mac
Question details
The user needs to include new 2024 records in an existing Excel PivotTable or linked PivotChart on a Mac.

- Product
- Microsoft Excel PivotTable and PivotChart
- Device & OS
- macOS
- Scenario
- New rows have been added to the worksheet, and the user wants the PivotTable and PivotChart to use those records.
- Observed behavior
- The existing PivotTable source does not include the new 2024 rows until its source range is expanded or converted to an Excel Table and refreshed.
Confirm that the 2024 rows use the same column headers and data layout as the existing source data. If the PivotTable is based on a linked PivotChart, update the PivotTable source rather than trying to change the chart data range separately.
Expand the PivotTable source range and refresh the report
Use this method when your PivotTable is based on a regular worksheet range and the new 2024 records are outside the current source selection.
Changing the PivotTable data source extends the report to the new rows. Refreshing then rebuilds the PivotTable and any PivotChart connected to it using the updated source.
Click any cell inside the PivotTable in your Excel worksheet.
On the PivotTable Analyze tab, select Change Data Source, then choose Change Data Source from the menu.
In the Table/Range box, select or type a source range that includes the original headers and all new 2024 records, then select OK.
Click PivotTable Analyze > Refresh, or Control-click the PivotTable and choose Refresh. The linked PivotChart updates from the refreshed PivotTable.

Convert the source data to an Excel Table for automatic row inclusion
Use this method when you will regularly add records and want future rows to be included after a simple refresh.
Update PivotTable Data Sources Easily with WPS Spreadsheets
WPS Spreadsheets lets you expand a PivotTable source range, use a structured data table for growing records, and refresh the PivotTable to include new yearly data. Its familiar spreadsheet interface helps you continue working with existing Excel files on Mac and other devices.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, select Spreadsheets, and open the Excel workbook containing the PivotTable.
- 2. Select the PivotTable: Click a cell inside the PivotTable to display the PivotTable tools.
- 3. Update the source data range: Use the PivotTable source or data range option and select the complete range containing the headers and newly added records.
- 4. Refresh the PivotTable: Choose Refresh from the PivotTable tools or right-click the PivotTable and select Refresh to recalculate the report.

Frequently Asked Questions
Why are my 2024 rows not showing in an Excel PivotTable on Mac?
The new rows are likely outside the PivotTable's current source range. Click inside the PivotTable, choose PivotTable Analyze > Change Data Source, expand the range to include the 2024 rows, and then choose Refresh.
Do I need to change the PivotChart source separately?
No. A PivotChart is linked to its PivotTable. Update the PivotTable source range and refresh the PivotTable; the connected PivotChart should update automatically.
How can I make future rows appear in my PivotTable without changing the range each time?
Convert the source range to an Excel Table through Insert > Table, then set the PivotTable source to that Table. Rows added directly below the Table are included when you refresh the PivotTable.
Can I refresh a PivotTable without changing its source range?
Yes, click inside the PivotTable and choose PivotTable Analyze > Refresh. However, refresh only updates records already inside the configured source range or source Table.
What should I check before changing a PivotTable source range?
Make sure the expanded range includes one header row and that every source column has a unique, nonblank header. Keep the new 2024 records in the same column structure as the existing data.




