OneDrive File Issues

Fix PowerPoint Links to Excel Charts in OneDrive

Natalie TaylorNatalie Taylor Nov 20, 2026 869 views

Question details

The user needs PowerPoint links to Excel charts in OneDrive to update when the source workbook is closed.

Fix PowerPoint Links to Excel Charts in OneDrive
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.
Before you start

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.

Solution 1Recommended

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.

1
Keep the workbook available

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.

2
Open link management

Open the presentation in PowerPoint and go to File > Info > Edit Links to Files, if the command is available.

3
Change the source

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.

4
Test with Excel closed

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.

Change the PowerPoint link source to the local OneDrive workbook
Changing many links: PowerPoint may require links to be changed individually. Test one link first; changing the path is not guaranteed to resolve every OneDrive link issue.
Free Microsoft Office alternative

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.

Open and edit PowerPoint PPTX presentations and Excel XLSX workbooksWork with presentations and spreadsheets in one Office suiteUse a familiar interface that makes switching from Microsoft Office easierAccess free, lightweight tools for everyday document editing
microsoft office alternative - wps office

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.