File Format & Compatibility

How to Fix Excel Folder Hyperlinks Not Working on Mac

John WilsonJohn Wilson Nov 4, 2026 871 views

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.

How to Fix Excel Folder Hyperlinks Not Working on 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.
Before you start

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.

Solution 1Recommended

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.

1
Organize Your Folders

Place the Excel workbook and the target folders (such as your photo directories) within the same parent folder on your device.

2
Edit the Hyperlink

Right-click the cell containing the broken folder hyperlink and select 'Edit Hyperlink' from the context menu.

3
Select Relative Location

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.

4
Save and Test

Save the Excel workbook and click the newly formatted link to ensure it successfully opens the correct folder on your Mac.

Change Absolute Paths to Relative Paths
Portability Advantage: Relative links will continue to work seamlessly even if you move the parent folder to a USB drive or cloud storage.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS Office website and download the installation package designed for macOS.
  2. 2. Install the Software: Open the downloaded installer and follow the quick on-screen instructions to set up WPS Office on your Mac.
  3. 3. Open Your Workbooks: Launch WPS Office and open your .xlsx files to enjoy a seamless, cross-platform spreadsheet experience.
100% compatible with Microsoft Excel (.xls and .xlsx) file formats.Free, lightweight application that runs flawlessly on macOS, Windows, Linux, and mobile devices.Familiar user interface requires zero learning curve for switching from Office.Built-in cloud synchronization allows seamless document transition across different hardware.
QA img-9

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.