File Format & Compatibility

Fix Excel External Links That Break Between Windows and Mac with Google Drive

Amos GikundaAmos Gikunda Nov 13, 2026 871 views

Question details

The user needs to understand why Excel external links break when a Google Drive workbook is opened on Windows and macOS, and how to make the links portable across operating systems.

Fix Excel External Links That Break Between Windows and Mac with Google Drive
Product
Microsoft Excel workbooks stored in Google Drive; compatible with WPS Office Spreadsheets
Device & OS
Windows and macOS
Scenario
A workbook with external links is stored in Google Drive and opened on both Windows and macOS.
Observed behavior
Mac links use /Volumes/GoogleDrive/Shared drives, while Windows links use a mapped G: drive, so linked files become unavailable on the other operating system.
Before you start

Before changing links, open the workbook and use Data > Edit Links to identify every external link, and note the exact source path shown on each operating system.

Solution 1Recommended

Replace Local Google Drive Paths with Web URLs

Best for cross-platform workbooks because an HTTPS URL is the same on Windows and macOS.

Excel stores the link exactly as entered, so operating-system-specific paths such as /Volumes/GoogleDrive/Shared drives and Windows G: drive references are not portable. Replacing them with a file URL in SharePoint, OneDrive, or Google Drive removes the local path dependence.

1
Open the workbook in WPS Office Spreadsheets

Launch WPS Office and open the affected .xlsx workbook that contains broken external links.

2
Open Edit Links

Click the Data tab, then choose Edit Links or Connections to display all external link sources.

3
Change the link source

Select the source that shows /Volumes/GoogleDrive/Shared drives or G: drive, click Change Source, and enter the HTTPS URL to the source workbook.

4
Save and test on both platforms

Save the workbook, then open it on Windows and macOS to confirm the Status column shows OK.

Replace Local Google Drive Paths with Web URLs
Portable link source: A web URL does not depend on the local Google Drive mount path, so the same link works on both operating systems.
WPS Office Spreadsheets

Fix Broken Excel External Links with WPS Office Spreadsheets

Open the affected Excel workbook in WPS Office Spreadsheets, change external link sources from operating-system-specific Google Drive paths to web URLs or same-folder references, and save a file that works on Windows and Mac.

  1. 1. Download and install WPS Office: Get WPS Office from the official WPS website and install it on Windows or Mac.
  2. 2. Open the workbook: Launch WPS Office Spreadsheets and open the Excel workbook that has broken external links.
  3. 3. List external links: Click the Data tab and choose Edit Links to display every external reference.
  4. 4. Change source: Select a broken link, click Change Source, and enter the HTTPS URL or browse to the source file in the same folder.
  5. 5. Save and verify: Save the workbook, then open it on Windows and macOS to confirm all links show OK.
Update .xlsx external links without losing Excel formatting or formulas.Microsoft Excel .xls, .xlsx, and .xlsm format compatibility.Free, lightweight spreadsheet tool with a familiar Data tab and Edit Links workflow.Avoid Windows G: drive and macOS /Volumes path conflicts by using portable link sources.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel workbook show broken links only when I switch from Mac to Windows?

Because Excel stores the absolute file path used when the link was created. Mac Google Drive links often use /Volumes/GoogleDrive/Shared drives, while Windows uses a mapped G: drive, so the path does not exist on the other OS.

Can WPS Office open and fix these external links?

Yes. Open the workbook in WPS Office Spreadsheets, go to Data > Edit Links, select the broken link, and use Change Source to point it to a URL or a file in the same folder.

What is the best external link format for a Google Drive workbook used on Windows and Mac?

Use an HTTPS URL to a file stored in SharePoint, OneDrive, or Google Drive, or keep all linked workbooks in the same synced folder and reference the file by name rather than by drive path.

Does mapping the same drive letter on Windows fix the issue on Mac?

It can help if all Windows PCs use the same mapped drive, but Mac path handling differs. A web URL or same-folder reference is usually safer. For Google Drive path mapping specifics, contact Google Drive Support.