File Sharing Problems

How to Fix Broken Excel External Links After Sharing via Google Drive

Phi Hung Vo Oct 10, 2026 872 views

Question details

The user needs to fix broken external links in Excel workbooks after sharing them via Google Drive.

Fix Broken Excel External Links After Sharing Files Through Google Drive

Product: Microsoft Excel
Device & OS: not provided
Scenario: Sharing linked Excel workbooks with other users through Google Drive.
Observed behavior: External workbook references break because the original local file path does not exist on the recipient's computer.

Before you start

Ensure you have access to both the master workbook and the source workbooks it links to, and verify that they are saved locally on your device before attempting to update the links.

Solution 1Recommended

Update External Links on the Recipient's Computer

Manually point the broken links to the new location of the source file on the recipient's local drive.

When a linked workbook is downloaded from Google Drive, the original absolute file path (e.g., C:\Users\Sender\Documents) no longer matches the recipient's computer structure. Updating the links manually reconnects the data.

Open the workbook

Launch Microsoft Excel and open the downloaded master workbook that contains the broken links.

Navigate to the Data tab

Click on the 'Data' tab located in the top Excel ribbon.

Access Edit Links

In the 'Queries & Connections' group, click on the 'Edit Links' button to open the link management dialog.

Change the source file

Select the broken link from the list, click 'Change Source...', and browse your local folders to select the downloaded source workbook. Click 'OK' to restore the connection.

Update External Links on the Recipient's Computer

Link Status Update: Once the source is successfully changed, the status in the Edit Links dialog will change from 'Error' to 'OK'.

Solution 2

Use Relative Paths Before Uploading to Google Drive

Store all linked workbooks in a single folder before creating links to rely on relative paths rather than absolute paths.

Efficient File Management

Easily Manage External Links with WPS Spreadsheet

WPS Spreadsheet offers full compatibility with Microsoft Excel files, allowing you to seamlessly open shared files and update broken external links in just a few clicks.

1. Open your file in WPS: Launch WPS Spreadsheet and open the downloaded workbook containing the external links.
2. Go to the Data tab: Navigate to the 'Data' tab located on the top ribbon interface.
3. Open Edit Links: Click on 'Edit Links' to view a complete list of all external workbook references.
4. Update the source: Select the broken link, choose 'Change Source', and locate the correct source file on your local computer.

Fully compatible with Microsoft Office formats, including .xls and .xlsx.Intuitive Data tab to easily manage, locate, and update external file references.Lightweight, fast to install, and completely free for standard office tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel links break when downloaded from Google Drive?

When you link workbooks locally, Excel stores the exact file path (e.g., C:\Users\Name\Documents). When the file is uploaded to Google Drive and downloaded by someone else, their computer directory structure is different, rendering the absolute path invalid and breaking the link.

Can I use Google Drive Desktop to keep Excel links intact?

Yes, if both users have Google Drive for Desktop installed and assign it to the exact same drive letter (such as G:), the absolute paths will match on both computers, allowing the external links to remain fully functional.

How do I find which external links are broken in my workbook?

Go to the 'Data' tab and click 'Edit Links'. The dialog box will list all external sources and display their current status. If the status says 'Error: Source not found', that specific link is broken and needs to be updated.

Document & File Issues