Fix PowerPoint Links to Excel Charts in OneDrive
Question details
The user needs PowerPoint links to Excel charts in OneDrive to update when the source workbook is closed.

- Product
- Microsoft PowerPoint, Microsoft Excel, and OneDrive
- Device & OS
- not provided
- Scenario
- A PowerPoint presentation links to charts in an Excel workbook stored in a locally synchronized OneDrive folder.
- Observed behavior
- The charts update while the workbook is open but fail when it is closed. The links may use an HTTPS d.docs.live.net source instead of a stable local path.
Make sure OneDrive is signed in and the source workbook is synchronized. In your file manager, locate the workbook in the OneDrive folder and confirm it is available offline.
Change the PowerPoint link source to the local OneDrive workbook
Use this approach when PowerPoint offers a link-management command and the current chart source uses an HTTPS address.
In your OneDrive folder, right-click the source Excel workbook and select Always keep on this device, if available. Wait for OneDrive to finish syncing.
Open the presentation in PowerPoint and go to File > Info > Edit Links to Files, if the command is available.
Select a link to the workbook, choose Change Source, and browse to the same workbook in the locally synchronized OneDrive folder. Repeat for other links as needed.
Save the presentation, close the source workbook in Excel, and use Update Now in the link-management dialog or reopen the presentation to check whether the chart updates.

Rebuild a linked chart using the local OneDrive path
Try rebuilding a link if changing its source does not work or link management is unavailable.
Work with presentations and spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing presentations and spreadsheets. Its Microsoft Office format support can help you migrate existing files, although it does not fix PowerPoint's OneDrive links.

Frequently Asked Questions
Why does the chart update only while the Excel workbook is open?
PowerPoint may be using an HTTPS source such as d.docs.live.net that does not resolve reliably when the workbook is closed. Check the source under File > Info > Edit Links to Files, if available, and try the locally synchronized workbook path.
Do I have to move the workbook out of OneDrive?
No. Try pointing PowerPoint to the workbook in your local OneDrive sync folder. Use Always keep on this device in the file manager if that option is available.
Can I change more than 20 links at once?
PowerPoint may require you to change links individually using Change Source. Test one link first; the available bulk options depend on the PowerPoint version and how the links were created.
What if Edit Links to Files is missing?
The command may not be available in your PowerPoint version or for the selected content. Try copying the chart from the locally synchronized workbook and using Home > Paste > Paste Special > Paste link to create a new linked chart.




