File Format & Compatibility

How to Fix Excel Links from Windows Not Working on Mac

Khadija KhanKhadija Khan Nov 3, 2026 871 views

Question details

Users experience broken Excel hyperlinks or data connections when opening a workbook on a Mac that was originally created on a Windows computer.

How to Fix Excel Links from Windows Not Working on Mac
Product
Spreadsheets
Device & OS
Mac / Windows
Scenario
Sharing or transferring Excel workbooks containing hyperlinks to external files or data features across different operating systems.
Observed behavior
Hyperlinks to external files fail to open, and connections to features like the Data Model do not function correctly on the Mac, though internal sheet-to-sheet links continue to work.
Before you start

Ensure you have all the original source files referenced by the workbook, and gather them into a single, shared folder before attempting to fix the links.

Solution 1Recommended

Use Relative Links for External Files

Creating relative links ensures that as long as the folder structure remains intact, the hyperlinks will work regardless of the operating system.

Absolute file paths on Windows (such as C:\Documents\Files\) do not exist on macOS, which causes external links to break when the file is transferred. Converting these to relative links solves the issue.

1
Group your files

Place the main Excel workbook and all its referenced source files into the exact same folder on your Windows computer.

2
Recreate the hyperlinks

Right-click the broken link, select 'Edit Hyperlink', and browse to the local file within that new shared folder instead of using the absolute drive path.

3
Share the entire folder

When sending the files to a Mac user, compress the entire folder into a ZIP file and share it, rather than sending only the workbook.

Link Portability: By keeping the files in the same relative directory, the Mac operating system will automatically resolve the file paths without needing a 'C:' drive reference.
Free Microsoft Office alternative

Experience Seamless Cross-Platform Spreadsheets with WPS Office

Avoid frustrating link breaks and compatibility issues when switching between Windows and Mac. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office, ensuring your spreadsheets and hyperlinks work smoothly on any operating system.

  1. 1. Download WPS Office: Get the free WPS Office installer for your Mac or Windows PC from the official website.
  2. 2. Open your workbook: Launch WPS Spreadsheet and open your existing .xlsx file without worrying about format conversion.
  3. 3. Manage links effortlessly: Enjoy native compatibility and seamless link management across your preferred operating systems.
100% compatibility with Microsoft Excel formats (.xlsx, .xls, .csv)Seamless performance across Windows, macOS, Linux, and mobile devicesIdentical user interface across platforms to drastically reduce learning curvesFree and lightweight alternative to heavy Office installations
QA img-9

Frequently Asked Questions

Why do internal sheet links work but external file links fail on Mac?

Internal links reference locations within the same document, which are independent of the operating system. External links often use absolute drive paths (like 'C:\') specific to Windows, which macOS cannot read or locate.

What is the difference between an absolute path and a relative path in spreadsheets?

An absolute path specifies the exact computer drive and folder structure (e.g., C:\Documents\file.xlsx). A relative path points to a file's location relative to the current workbook's folder, making it portable and functional across different computers and devices.

Are Data Model connections fully supported on Mac?

Support for Data Model links is limited and still improving on macOS. Complex Data Models built on Windows may occasionally fail when updated, refreshed, or interacted with on a Mac.