Fix Linked Excel Chart Named Range Changing to [0] in PowerPoint
Question details
Users need to fix an issue where the external named-range reference of an Excel chart linked in a PowerPoint presentation breaks upon reopening.
![How to Fix Linked Excel Chart Named Range Changing to [0] in PowerPoint](https://res-academy.cache.wpscdn.com/upload/seo-engine-admin/2026-10-16/7141ed96c9b75dd351ac417136bb7ae9.png)
- Product
- Microsoft PowerPoint and Excel
- Device & OS
- not provided
- Scenario
- Working with a PowerPoint presentation that contains live-linked charts from an external Excel workbook.
- Observed behavior
- After closing and reopening the PowerPoint file, the linked Excel chart's named-range reference unexpectedly changes from the valid external workbook path to [0].
Make sure your internet connection is active so you can check for software updates, and save a backup copy of your PowerPoint and Excel files.
Update Microsoft Office to the Latest Version
Installing the latest Office updates is the most effective way to patch known software bugs related to object linking and embedding (OLE).
Microsoft frequently releases updates to fix compatibility and linking bugs between Excel and PowerPoint. Ensuring you are on the latest build usually restores normal link behavior.
Open Microsoft PowerPoint or Excel. Click on 'File' in the top-left corner of the ribbon, then select 'Account' (or 'Office Account') from the bottom of the left sidebar.
Look for the 'Office Updates' section on the right side. Click the 'Update Options' button and select 'Update Now' from the drop-down menu.
Wait for the updates to download and install. Once completed, restart your computer, open your PowerPoint presentation, and verify if the linked chart retains its correct named range.
Re-establish the Excel Chart Link
If updating Office does not retroactively fix the broken links, you will need to manually recreate the connection between the files.
Switch to WPS Office for Reliable File Compatibility
If you are tired of dealing with broken links and unexpected software bugs in Microsoft Office, consider switching to WPS Office. It provides a stable, lightweight, and highly compatible environment for your spreadsheets and presentations.
Frequently Asked Questions
Why does my Excel chart link path change to [0] in PowerPoint?
This is typically caused by a specific version bug within Microsoft Office's handling of OLE (Object Linking and Embedding) and named ranges. Updating the Microsoft 365 apps to the latest build generally patches this issue.
How can I stop linked charts from breaking when sending files to someone else?
External links rely on absolute file paths on your local drive. To prevent them from breaking when sharing, place both the Excel and PowerPoint files in the same folder before creating the link, and share the entire folder as a ZIP file. Alternatively, copy and paste the chart without choosing 'Paste link' to embed the data directly.
Where can I find my exact Microsoft Office build number?
Open any Office application like PowerPoint, click on 'File', and select 'Account'. Under the 'About PowerPoint' section on the right side, you will see the exact Version and Build number listed.
Does WPS Office support linking Excel data into presentations?
Yes, WPS Office supports linking objects. You can copy a chart from WPS Spreadsheet and use 'Paste Special' > 'Paste link' in WPS Presentation to keep your charts dynamically updated when the source data changes.
