SharePoint Document Issues

Fix Excel Cannot Update Workbook Links on SharePoint

Guest Writer Sep 25, 2026 869 views

Question details

The user is unable to update data links between Excel workbooks stored in the same SharePoint folder.

How to Fix Excel Cannot Update Workbook Links on SharePoint

Product: Microsoft Excel, SharePoint
Device & OS: not provided
Scenario: Attempting to refresh or update connected data links between multiple Excel files hosted on a SharePoint site.
Observed behavior: Excel fails to update the links, reporting that the source file is on another domain. The links only function correctly if the files are downloaded to a local drive.

Before you start

Before troubleshooting, ensure you have a stable internet connection and that you are actively signed into your Microsoft 365 account with the correct edit permissions for the target SharePoint folder.

Solution 1Recommended

Verify SharePoint Paths, Tenant, and Permissions

Check if structural changes in SharePoint or mismatched tenant domains have broken the connection between the linked workbooks.

Often, Excel reports domain errors if the file paths have changed slightly, or if the files are being accessed through different sharing links that route through external domains.

Verify Tenant and File URL

Open SharePoint in your browser and navigate to the folder containing both workbooks. Check the address bar to ensure both files reside within the exact same Microsoft 365 tenant domain.

Check Sharing Permissions

Right-click both Excel files in the SharePoint document library, select 'Manage Access', and ensure your account has full edit permissions for both source and destination workbooks.

Manually Re-establish Links

Open the destination workbook in the Excel desktop app. Go to the 'Data' tab, click 'Edit Links' in the Queries & Connections group, select the broken link, click 'Change Source', and browse to the correct SharePoint URL to reset the path.

Verify SharePoint Paths, Tenant, and Permissions

Relative vs Absolute Paths: Always try to open both the source and destination workbooks in the desktop app simultaneously when creating links so Excel registers the correct SharePoint relative paths.

Solution 2

Escalate to Microsoft 365 Support

If tenant configurations are correct but the cross-domain error persists, the issue may stem from a backend SharePoint service incident that requires administrative intervention.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you are experiencing persistent server-side linking issues with Microsoft SharePoint and Excel, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for handling complex spreadsheets offline and via cloud storage without the frequent domain errors.

1. Download and Install: Visit the official WPS website to download the free WPS Office suite for your operating system.
2. Open Your Workbooks: Launch WPS Spreadsheet and easily open your existing .xlsx files directly from your local drive or connected cloud storage.
3. Manage Data Links smoothly: Use the intuitive Data tab in WPS Spreadsheet to manage workbook connections and external links efficiently.

Highly compatible with Microsoft Excel (.xlsx, .xls) and CSV formats.Reliable local and cloud file linking without complex domain authentication errors.Lightweight installation with a familiar user interface for immediate productivity.Free to use with built-in PDF tools and advanced data formatting options.

microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel links break when uploaded to SharePoint?

When uploaded to SharePoint, file paths change from local drive letters (like C:\) to web-based URLs (https://...). If the workbooks were linked using absolute local paths rather than relative paths, Excel fails to locate the destination file once it is moved to the cloud.

Can I use OneDrive syncing to fix SharePoint link issues?

Yes. By using the 'Sync' button in your SharePoint document library, you map the folder to your local computer via OneDrive. Opening the synced files through your local File Explorer often bypasses the domain URL error because Excel treats them as local files.

How do I check current workbook links in Excel?

Open your Excel workbook, navigate to the 'Data' tab on the ribbon, and click 'Edit Links' (if the button is grayed out, your workbook has no external links). This dialog box displays all linked files, their current paths, and their update status.

Document & File Issues