Fix Excel HYPERLINK Function Not Opening JPG Files on Mac
Question details
The user needs an Excel HYPERLINK formula on Mac to open a local JPG image file successfully.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A worksheet contains a HYPERLINK formula that points to a JPG file. A manually inserted hyperlink may work, but the formula-based link does not.
- Observed behavior
- Selecting the HYPERLINK formula does not open the JPG file as expected.
Confirm that the JPG file still exists and that you can open it directly in Finder. Keep the workbook and image in stable locations while testing, because moving either item can break a local file link.
Correct the local JPG file URL in the HYPERLINK formula
Use this solution when the HYPERLINK formula points to the wrong location or does not use a Mac-compatible local file URL.
For a local image on macOS, use a complete file URL beginning with file:/// and make sure the path exactly matches the file location. Folder names, file extensions, spaces, and special characters must be represented correctly.
In Finder, locate the JPG file, then hold Option, right-click the file, and select Copy “file name” as Pathname if that command is available.
In the target cell, use a formula such as =HYPERLINK("file:///Users/yourname/Pictures/photo.jpg","Open JPG"). Replace the path with the exact location of your image file.
If the path contains spaces or special characters, edit the formula carefully. For example, a space in a file URL may need to appear as %20.
Move a test JPG to a simple location such as your Pictures folder, then create a new workbook and test a HYPERLINK formula to that file.

Allow Excel to access the folder that contains the JPG file
Use this solution when the path is correct but Excel cannot access files stored in protected macOS locations.
Update Excel and isolate workbook-specific settings
Use this solution when valid links fail only in one workbook or after Excel settings have changed.
Open and manage image links in WPS Spreadsheets
If Microsoft Excel for Mac continues to block or fail to follow local JPG links, try WPS Office as a free, lightweight alternative. WPS Spreadsheets offers a familiar worksheet interface and supports common Microsoft Office formats, helping you move existing files with minimal adjustment.
- 1. Install WPS Office: Download and install WPS Office on your Mac, then open WPS Spreadsheets.
- 2. Open the Excel workbook: Select Open and choose the existing .xlsx or .xls workbook that contains the JPG hyperlink.
- 3. Review the hyperlink formula: Select the formula cell and verify that the JPG file URL uses the correct local path.
- 4. Test and save the workbook: Select the hyperlink to test it, then use File > Save As to save a copy in Excel .xlsx format if you need to share it with Excel users.

Frequently Asked Questions
What file path format should I use for a JPG link in Excel for Mac?
Use a complete local file URL starting with file:///. For example: =HYPERLINK("file:///Users/yourname/Pictures/photo.jpg","Open JPG"). The path must match the image location exactly.
Why does an inserted hyperlink work but the HYPERLINK function does not?
An inserted link may be stored or handled differently from a formula URL. Compare the target of the inserted link with the HYPERLINK formula, especially the file:/// prefix, spaces, and special characters.
How do I give Excel permission to open files in a Mac folder?
Go to Apple menu > System Settings > Privacy & Security. Check Files and Folders or Full Disk Access, locate Microsoft Excel if available, and allow access to the folder category that contains the JPG.
Do spaces in a JPG file path affect Excel HYPERLINK links on Mac?
They can. A file URL may require spaces to be encoded as %20. Rename the file and folders with simple names for testing, or update the URL so special characters are properly encoded.
Can I use WPS Spreadsheets to open an Excel workbook with hyperlinks?
Yes. WPS Spreadsheets can open and edit common Excel .xlsx and .xls files. After opening the workbook, review the hyperlink target and test whether the linked local JPG is accessible on your Mac.




