'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Table Rows Not Updating in Linked PowerPoint Chart
Question details
The user needs a solution for a linked PowerPoint chart that successfully updates existing data but fails to display newly added rows from the source Excel table.
- Product
- Microsoft Excel and PowerPoint
- Device & OS
- not provided
- Scenario
- Presenting dynamically updated data in PowerPoint by linking a chart to an expanding Excel table.
- Observed behavior
- Existing values and labels in the linked PowerPoint chart update correctly, but new rows added to the source Excel table do not appear, despite automatic updates being enabled and the Excel chart itself updating normally.
Ensure that both your Excel workbook and PowerPoint presentation are saved in the same local directory, and keep the Excel file open while attempting to refresh the presentation links.
Manually Update the Chart Data Range in PowerPoint
Force PowerPoint to recognize the newly added rows by manually refreshing the selected data range within the presentation.
Due to a known limitation in how PowerPoint caches linked chart ranges, expanding the source table in Excel does not automatically expand the bounding box of the chart data in PowerPoint. You must manually re-select the range to include the new rows.
Open your PowerPoint presentation and click on the linked chart that is failing to display the new rows.
Navigate to the 'Chart Design' tab on the top ribbon and click on 'Select Data'. This action will automatically open the linked Excel workbook.
In the Excel window that appears, highlight the entire table again, making sure to include the newly added rows. Click 'OK' on the Select Data Source dialog box to apply the changes to your PowerPoint chart.
Paste the Chart as a Linked OLE Object
Bypass native chart linking limitations by pasting the entire Excel chart as a linked OLE object, which perfectly mirrors the Excel view.
Experience Seamless Data Linking with WPS Office
If linking Microsoft Excel and PowerPoint charts continues to cause data synchronization defects, consider switching to WPS Office. It provides a reliable, free, and highly compatible suite that makes updating linked spreadsheet data in presentations effortless.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
- 2. Open Your Existing Files: Open your .xlsx workbooks and .pptx presentations directly in WPS Office without losing any formatting or data.
- 3. Link Charts Easily: Create your dynamic chart in WPS Spreadsheet, copy it, and use 'Paste Special' > 'Paste Link' in WPS Presentation for flawless real-time updates.
Frequently Asked Questions
Why do existing chart values update but not the newly added rows in PowerPoint?
This is a known architectural limitation between Excel and PowerPoint. PowerPoint caches the original dimensions (rows and columns) of the linked data range. While the values within that specific bounding box can update automatically, expanding the box to include new rows requires a manual refresh of the data source.
Does enabling 'Automatic Link Update' fix the row addition issue?
No. The 'Automatic Update' feature in PowerPoint only refreshes the data values that exist inside the originally defined chart range. Newly appended rows fall outside this fixed boundary and will be ignored until the range is manually redefined.
How can I check the current link settings for my presentation?
In PowerPoint, navigate to File > Info. At the bottom right of the Info pane, click on 'Edit Links to Files' (this option only appears if the presentation contains links). Here you can view, update, open, or break the links to your source Excel files.
