How to Fix Excel Links from Windows Not Working on Mac
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.

- 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.
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.
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.
Place the main Excel workbook and all its referenced source files into the exact same folder on your Windows computer.
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.
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.
Address Data Model and Internal Link Limitations
Understand which links are fully supported on Mac and how to handle Data Model references.
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. Download WPS Office: Get the free WPS Office installer for your Mac or Windows PC from the official website.
- 2. Open your workbook: Launch WPS Spreadsheet and open your existing .xlsx file without worrying about format conversion.
- 3. Manage links effortlessly: Enjoy native compatibility and seamless link management across your preferred operating systems.

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.




