File Format & Compatibility

How to Fix Excel Links Between Windows and Mac Shared Folders

Maira MehtabMaira Mehtab Oct 12, 2026 871 views

Question details

Users experience broken external workbook links in Excel when collaborating across Windows and macOS over shared network folders.

How to Fix Broken Excel Links Between Windows and Mac Shared Folders
Product
Microsoft Excel
Device & OS
Windows and macOS
Scenario
Collaborating on linked Excel workbooks stored on a shared network drive across different operating systems.
Observed behavior
Excel workbook links fail or break because Windows and Mac represent shared network paths differently, preventing Excel from translating the paths reliably.
Before you start

Before restructuring your files, back up your current workbooks and document your existing folder hierarchy on the shared network drive to ensure no data is lost.

Solution 1Recommended

Reorganize Folders to Use File-Relative Links

Place your linked data files in the same folder as your main workbook or in a direct child folder to prevent cross-platform path translation errors.

When linked workbooks are stored in parent or sibling directories, Excel uses server-relative or absolute paths. Since Windows represents network paths with drive letters and macOS uses mounted volume paths, Excel cannot consistently translate them. By grouping files in the same or child folder, Excel is forced to use file-relative links, which work seamlessly across both operating systems.

1
Create a unified project folder

Open File Explorer (Windows) or Finder (Mac) and create a new master folder on your shared network drive.

2
Move linked workbooks

Move your main Excel workbook and all associated data files into this single master folder or its subfolders.

3
Update links in Excel

Open your main workbook in Excel. Go to the 'Data' tab on the ribbon and click on 'Edit Links' (or 'Queries & Connections' depending on your Excel version).

4
Change source paths

Click 'Change Source' and select the files from their new location within the unified project folder to establish the new file-relative links.

Reorganize Folders to Use File-Relative Links
Best Practice: Maintaining a self-contained folder structure is the most reliable way to ensure cross-platform link stability without changing software.
Free Microsoft Office alternative

Try WPS Office for Seamless Cross-Platform Management

Since network path differences between Windows and Mac can cause frustrating link breaks in Microsoft Office, consider switching to WPS Office. It is a highly compatible, free, and lightweight alternative with built-in cloud capabilities that makes cross-platform collaboration effortless.

  1. 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your respective Windows or Mac device.
  2. 2. Install and Launch: Follow the on-screen instructions to install the software, then launch the WPS Spreadsheets application.
  3. 3. Open Your Excel Files: Click 'Open' and select your existing .xlsx workbooks. WPS Office offers excellent compatibility, ensuring your data formatting is seamlessly preserved.
100% compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Free, lightweight, and fast alternative to Microsoft Office.Built-in WPS Cloud ensures your files and links are accessible across Windows, Mac, and Linux.Familiar user interface with a zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel links break when switching between Windows and Mac?

Windows uses drive letters (e.g., Z:\Folder) for shared network locations, whereas macOS uses mounted volumes (e.g., /Volumes/Folder). Excel struggles to translate these absolute OS-specific paths automatically, resulting in broken links when the other operating system attempts to locate the file.

What are file-relative links in Excel?

File-relative links define the path of a linked file based on its location relative to the current workbook, rather than the entire computer or server path. Excel automatically creates them when the linked file is placed in the exact same folder or a subfolder of the main workbook.

Does the legacy Shared Workbook feature fix cross-platform path issues?

No. The legacy Shared Workbook feature allows multiple users to edit a file simultaneously, but it does not resolve the underlying OS-level path translation issues for external data links.

Can I use absolute paths for shared workbooks across different operating systems?

It is highly discouraged. If users on both Windows and macOS need to access the files, absolute paths will inevitably break because they are inherently tied to the specific directory structure of the operating system that created the link.