Pivot Table Issues

Add 2024 Records to an Excel PivotTable or PivotChart on Mac

Rana GarciaRana Garcia Nov 12, 2026 869 views

Question details

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

Add 2024 Records to an Excel PivotTable or PivotChart on 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.
Before you start

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.

Solution 1Recommended

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.

1
Select the PivotTable

Click any cell inside the PivotTable in your Excel worksheet.

2
Open the data source settings

On the PivotTable Analyze tab, select Change Data Source, then choose Change Data Source from the menu.

3
Include the 2024 rows

In the Table/Range box, select or type a source range that includes the original headers and all new 2024 records, then select OK.

4
Refresh the PivotTable

Click PivotTable Analyze > Refresh, or Control-click the PivotTable and choose Refresh. The linked PivotChart updates from the refreshed PivotTable.

Expand the PivotTable source range and refresh the report
PivotChart updated: A PivotChart uses its associated PivotTable as its source, so refreshing the updated PivotTable also includes the new records in the chart.
WPS Spreadsheets

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. 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, select Spreadsheets, and open the Excel workbook containing the PivotTable.
  2. 2. Select the PivotTable: Click a cell inside the PivotTable to display the PivotTable tools.
  3. 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. 4. Refresh the PivotTable: Choose Refresh from the PivotTable tools or right-click the PivotTable and select Refresh to recalculate the report.
Refresh PivotTables after adding new records to the source dataUse tables to keep expanding datasets ready for PivotTable analysisOpen and edit Microsoft Excel .xlsx and .xls workbooksCreate PivotTables and charts with a familiar spreadsheet workflow
microsoft office alternative - wps office

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.