SharePoint Document Issues

Fix PowerPoint Links to SharePoint Excel Files Not Updating

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to fix an issue where linked Excel data in a PowerPoint presentation fails to update after the files are closed and reopened in SharePoint.

Product: PowerPoint, Excel, SharePoint
Device & OS: not provided
Scenario: Maintaining dynamic data links between an Excel workbook and a PowerPoint presentation hosted on SharePoint.
Observed behavior: Links to the Excel workbook work immediately upon creation but stop refreshing or updating once both the presentation and the workbook are reopened.

Before you start

Ensure that your OneDrive or SharePoint synchronization client is currently running, up to date, and connected to the internet to properly resolve cloud file paths.

Solution 1

Verify File Storage Locations and Cloud Link Paths

Check that both files are properly stored in SharePoint and that the PowerPoint links target the SharePoint versions instead of temporary local copies.

When files are uploaded to SharePoint, PowerPoint sometimes retains the local path for linked objects. Verifying the source path ensures PowerPoint is looking in the correct cloud directory.

Open File Information

Open the PowerPoint presentation in the desktop application and navigate to 'File' > 'Info'.

Access Link Settings

Scroll to the bottom right of the Info pane and click on 'Edit Links to Files'.

Verify the Source Path

Check the 'Source' column for your Excel links. Confirm that the path begins with 'https://' pointing to your SharePoint directory rather than 'C:\Users\'.

Solution 2Recommended

Recreate Links Using Synchronized Local Files

Re-establish the data links using the local SharePoint synced folders to ensure stable synchronization and correct path resolution upon reopening.

Free Microsoft Office alternative

Experience Seamless Cross-File Linking with WPS Office

Tired of dealing with broken SharePoint links and complex sync issues in Microsoft Office? WPS Office offers a highly compatible, lightweight alternative where managing data links between spreadsheets and presentations is straightforward and reliable.

1. Download and Install: Get WPS Office from the official website and install it quickly on your PC or Mac.
2. Open Your Office Files: Directly open your existing PPTX and XLSX files in WPS Office without losing any formatting.
3. Link Data Easily: Use the familiar Paste Special > Paste Link feature to keep your presentation data synchronized with your spreadsheets.

Fully compatible with Microsoft Office formats including PPTX, XLSX, and DOCX.Seamlessly link data and charts between WPS Spreadsheet and WPS Presentation.Lightweight installation with a user-friendly, familiar tabbed interface.Built-in cloud storage integration for reliable file syncing without path conflicts.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my PowerPoint links to Excel break when uploaded to SharePoint?

When files are moved to SharePoint, the absolute local file paths in the OLE links change to web URLs. If the files are not synced properly or if PowerPoint fails to convert the local path to the SharePoint URL, the links will break and fail to update.

How do I force PowerPoint to update links automatically upon opening?

Go to File > Options > Advanced, scroll down to the General section, and check 'Update automatic links at open'. Note that for files stored on SharePoint, you may still need to click 'Update Links' manually if the cloud sync is delayed.

Can I update linked Excel data in PowerPoint for the web?

No, PowerPoint for the web does not support updating OLE links or external data connections. You must open the presentation in the desktop application to successfully refresh linked Excel data.

Document & File Issues