File Sharing Problems

How to Fix Broken Excel and PowerPoint Links in SharePoint

Kushani Nimanthika Oct 16, 2026 869 views

Question details

The user needs to maintain working data links between an Excel workbook and a PowerPoint presentation when both files are stored in a shared SharePoint folder.

How to Fix Excel and PowerPoint Links Breaking in SharePoint

Product: Microsoft Excel, Microsoft PowerPoint, SharePoint
Device & OS: not provided
Scenario: Collaborating on or presenting data using a PowerPoint file that relies on live data linked from an Excel workbook located in the same cloud directory.
Observed behavior: The data links work perfectly while both files are open, but PowerPoint fails to locate the linked Excel workbook after the files are closed and reopened.

Before you start

Ensure you have downloaded both the Excel workbook and the PowerPoint presentation to a folder on your local hard drive before attempting to repair the file links.

Solution 1Recommended

Use Local Folders to Create and Update Links

Moving the files to a local drive ensures the file paths remain static and recognizable by the operating system, bypassing SharePoint's cloud URL handling issues.

Linking between Office files stored on OneDrive or SharePoint can be unreliable because cloud paths use web URLs (HTTPS) rather than traditional local directory paths. When the files are closed, PowerPoint often struggles to resolve the web URL to find the source Excel file.

Download the files locally

Navigate to your SharePoint or OneDrive folder, select both the Excel workbook and the PowerPoint presentation, and download them to a single folder on your local hard drive.

Recreate the links

Open both files from your local folder. In Excel, copy the data you want to link. In PowerPoint, go to the 'Home' tab, click the arrow under 'Paste', select 'Paste Special', and choose 'Paste Link'.

Verify and save

Save and close both files. Reopen the PowerPoint presentation to verify that it successfully updates the linked data without errors.

Upload back to SharePoint

Once the presentation is finalized and the links are confirmed working locally, upload both files back to the SharePoint folder for sharing.

Use Local Folders to Create and Update Links

Updating in the future: Whenever you need to update the source data again, it is highly recommended to repeat this process by updating the files locally before re-uploading them to the cloud.

Solution 2

Embed the Excel Content Instead of Linking

Embedding the Excel file directly into the PowerPoint presentation avoids broken links entirely, which is ideal if a live external link is not strictly required.

Free Microsoft Office alternative

Try WPS Office for Seamless Presentation and Spreadsheet Management

If you frequently encounter frustrating file linking issues or cloud path errors in Microsoft Office, consider switching to WPS Office. It provides a free, lightweight, and highly compatible alternative for handling documents, spreadsheets, and presentations without the heavy cloud-sync errors.

1. Download and Install: Visit the official WPS website to download and install WPS Office for free on your device.
2. Open Your Files: Launch WPS Office and open your existing .xlsx and .pptx files directly within the unified tabbed workspace.
3. Link Data Seamlessly: Copy your data in WPS Spreadsheet, switch to your WPS Presentation tab, and use 'Paste Special' to easily create stable data links.

Fully compatible with Microsoft PowerPoint (.pptx) and Excel (.xlsx) formatsLightweight desktop client that handles local and linked files smoothlyFamiliar tabbed interface that requires zero learning curveFree to use with built-in cloud storage for reliable file sharing

Frequently Asked Questions

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

SharePoint and OneDrive use web-based URL paths (HTTPS) instead of traditional local drive paths. Office applications sometimes struggle to resolve these cloud URLs correctly after the files are closed and reopened, resulting in broken data links.

Can I fix broken PowerPoint links without downloading the files manually?

Yes, you can try syncing the SharePoint folder to your local computer using the OneDrive desktop client. This creates a local file path on your machine, which often allows PowerPoint to resolve the link to the Excel file. However, downloading them to an un-synced local folder remains the most reliable workaround.

What is the difference between linking and embedding in PowerPoint?

Linking connects the PowerPoint to an external Excel file, meaning changes made in Excel will automatically update in PowerPoint, and the presentation file size stays small. Embedding places a full copy of the Excel data directly inside the PowerPoint file, preventing broken links but increasing the overall file size.

How do I check for broken links in my PowerPoint presentation?

Go to the 'File' tab, click 'Info', and look for 'Related Documents' in the bottom right corner. Click 'Edit Links to Files' to view the status of all external links. From there, you can update the paths, open the source, or break the links if they are no longer needed.

Document & File Issues