Fix Excel External Links That Break Between Windows and Mac with Google Drive
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.

- 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 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.
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.
Launch WPS Office and open the affected .xlsx workbook that contains broken external links.
Click the Data tab, then choose Edit Links or Connections to display all external link sources.
Select the source that shows /Volumes/GoogleDrive/Shared drives or G: drive, click Change Source, and enter the HTTPS URL to the source workbook.
Save the workbook, then open it on Windows and macOS to confirm the Status column shows OK.

Keep Linked Files in the Same Folder and Use File-Name References
Use when all linked workbooks are stored together and can be synced to the same relative location.
Use a Consistent Mapped Drive or Google Drive Streaming Path on Each Computer
Use when your team can enforce identical drive mappings and sync settings on every computer.
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. Download and install WPS Office: Get WPS Office from the official WPS website and install it on Windows or Mac.
- 2. Open the workbook: Launch WPS Office Spreadsheets and open the Excel workbook that has broken external links.
- 3. List external links: Click the Data tab and choose Edit Links to display every external reference.
- 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. Save and verify: Save the workbook, then open it on Windows and macOS to confirm all links show OK.

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.




