Function Problems

Fix Excel HYPERLINK Function Not Opening JPG Files on Mac

Elise WilliamsElise Williams Nov 12, 2026 868 views

Question details

The user needs an Excel HYPERLINK formula on Mac to open a local JPG image file successfully.

Fix Excel HYPERLINK Function Not Opening JPG Files on Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Copy the image path from Finder

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.

2
Enter a full file URL in Excel

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.

3
Check spaces and special characters

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.

4
Test with a simple local file

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.

Correct the local JPG file URL in the HYPERLINK formula
Use the full path: A relative path or a Windows-style path using backslashes may not work correctly in Excel for Mac.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install WPS Office on your Mac, then open WPS Spreadsheets.
  2. 2. Open the Excel workbook: Select Open and choose the existing .xlsx or .xls workbook that contains the JPG hyperlink.
  3. 3. Review the hyperlink formula: Select the formula cell and verify that the JPG file URL uses the correct local path.
  4. 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.
Create and manage hyperlinks in WPS Spreadsheets.Open and edit Microsoft Excel .xlsx and .xls workbooks with strong format compatibility.Use a familiar spreadsheet interface for a smoother transition from Excel.Work with a lightweight, free office suite for everyday spreadsheet tasks.
microsoft office alternative - wps office

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.