How to Fix Excel Folder Hyperlinks Not Working on Mac
Question details
The user needs to fix folder hyperlinks in an Excel workbook that successfully open on a Windows PC but fail to respond or produce an error when clicked on a Mac.

- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Accessing an Excel workbook transferred from Windows to Mac that contains multiple hyperlinks pointing to local directories or network photo folders.
- Observed behavior
- Folder hyperlinks click normally on Windows and open the file explorer, but clicking the identical links on a Mac results in no action or throws an error because the macOS file system cannot parse Windows-formatted file paths.
Determine whether the linked folders are stored locally on your hard drive or hosted on an external network server, as this dictates the correct file path format required for macOS.
Change Absolute Paths to Relative Paths
Recreate the links as relative paths so they remain valid across both Windows and macOS, provided the workbook and target folders keep the same structure.
An absolute path includes the full drive letter and directory tree (e.g., C:\Photos). When moved to a Mac, this path becomes invalid because macOS does not use drive letters. By utilizing a relative path, Excel simply looks for the folder relative to where the workbook is currently saved, making it fully portable.
Place the Excel workbook and the target folders (such as your photo directories) within the same parent folder on your device.
Right-click the cell containing the broken folder hyperlink and select 'Edit Hyperlink' from the context menu.
In the hyperlink dialog, clear the absolute path. Browse to and select the target folder directly within the current directory structure, ensuring no hardcoded drive letter is included in the address field.
Save the Excel workbook and click the newly formatted link to ensure it successfully opens the correct folder on your Mac.

Use SMB Addresses for Network Folders
Update network folder hyperlinks to use the Mac-compatible Server Message Block (SMB) format instead of Windows UNC paths.
Try WPS Office for Free and Seamless Cross-Platform Spreadsheets
If you frequently share files between Mac and Windows, managing path compatibilities and operating system quirks in Microsoft Excel can be frustrating. WPS Office offers a lightweight, completely free alternative that ensures high compatibility across different platforms. With robust tools and a unified interface, you can manage your workbooks easily on both operating systems.
- 1. Download WPS Office: Visit the official WPS Office website and download the installation package designed for macOS.
- 2. Install the Software: Open the downloaded installer and follow the quick on-screen instructions to set up WPS Office on your Mac.
- 3. Open Your Workbooks: Launch WPS Office and open your .xlsx files to enjoy a seamless, cross-platform spreadsheet experience.

Frequently Asked Questions
Why do my Excel links work perfectly on Windows but break on Mac?
Windows and macOS use fundamentally different file systems. Windows uses drive letters (like C:\) and backslashes (\) for folder paths, whereas macOS is UNIX-based and uses forward slashes (/). Hyperlinks hardcoded with Windows-specific paths cannot be parsed by Mac's Finder.
What is the difference between relative and absolute hyperlinks in Excel?
An absolute hyperlink contains the full file path to the destination (e.g., C:\Users\Name\Photos\), which will break if the file is moved to another computer. A relative hyperlink points to a location relative to the workbook's current folder (e.g., \Photos\), making it highly adaptable and cross-platform friendly.
How can I mass convert broken Excel network hyperlinks on a Mac?
If you have hundreds of links, you can use a VBA macro to automate the fix. Press Option + F11 on your Mac to open the VBA Editor, insert a new module, and run a script to replace backslashes with forward slashes or add the 'smb://' prefix to all active network paths in your workbook.




