How to Fix Excel Links Between Windows and Mac Shared Folders
Question details
Users experience broken external workbook links in Excel when collaborating across Windows and macOS over shared network 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 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.
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.
Open File Explorer (Windows) or Finder (Mac) and create a new master folder on your shared network drive.
Move your main Excel workbook and all associated data files into this single master folder or its subfolders.
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).
Click 'Change Source' and select the files from their new location within the unified project folder to establish the new file-relative links.

Migrate Files to Cloud Storage
Use cloud services like OneDrive or SharePoint instead of local network shares to standardize file paths.
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. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your respective Windows or Mac device.
- 2. Install and Launch: Follow the on-screen instructions to install the software, then launch the WPS Spreadsheets application.
- 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.

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.




