Office for Mac Issues

Fix Excel for Mac Hyperlink Formulas That Cannot Open Local PDFs

Steven ParkerSteven Parker Nov 14, 2026 868 views

Question details

The user needs to open local PDF files from HYPERLINK formulas in a newer version of Excel for Mac.

Fix Excel for Mac Hyperlink Formulas That Cannot Open Local PDFs
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
A workbook uses HYPERLINK formulas to open PDF files stored on the Mac.
Observed behavior
The formulas open PDFs in Excel 14.7.7 but report that the file cannot be opened in Excel 16.26. Manually inserted links may still work.
Before you start

Confirm that the PDF opens in Finder and note its current local path. Check whether Excel displays a folder-access prompt when you try the link.

Solution 1Recommended

Check Excel's folder access and test an inserted hyperlink

Use this approach to check macOS permissions and see whether a manually inserted link can open the same PDF.

Newer versions of Excel for Mac follow macOS sandboxing requirements, which can restrict access to local files. Permission settings and prompts vary by macOS version and folder.

1
Check folder permissions

Open System Settings > Privacy & Security > Files and Folders, or System Preferences > Security & Privacy > Privacy > Files and Folders on older macOS versions. If Microsoft Excel and the relevant folder are listed, allow access.

2
Respond to an access prompt

In Excel, click the formula-generated link again. If macOS or Excel asks for access to the PDF or its folder, select the requested location and allow access.

3
Insert a link manually

Select a cell, choose Insert > Link or Hyperlink, and use the file-selection option to select the same local PDF. Click the inserted link to test it.

Check Excel's folder access and test an inserted hyperlink
Compare the results: If the inserted link works but the HYPERLINK formula does not, use the inserted link as a workaround. Folder permission alone may not resolve every formula-link restriction.
Free Microsoft Office alternative

Work with Excel Spreadsheets in WPS Office for Mac

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and compatibility with Excel files, making it easier to move existing workbooks. It does not change Excel's macOS permissions; test local PDF links and grant access if prompted.

Open and edit Microsoft Excel XLSX and XLS filesWork with spreadsheet hyperlinks in a familiar interfaceUse a free, lightweight office suite on MacMove existing spreadsheets into WPS Office without starting over
microsoft office alternative - wps office

Frequently Asked Questions

Why did the PDF link work in an older version of Excel for Mac?

Newer Excel versions follow macOS sandboxing requirements that can restrict access to local files. Excel 2011 did not use the same sandboxing model.

Where can I check whether Excel has access to my PDF folder?

Open System Settings > Privacy & Security > Files and Folders. If Excel and the relevant folder are listed, allow access. On older macOS versions, look under System Preferences > Security & Privacy > Privacy.

What if a manually inserted link works but the formula does not?

Select the cell and use Insert > Link or Hyperlink to link to the PDF directly. An inserted hyperlink can work differently from a HYPERLINK formula, although macOS permissions may still apply.

Will a VBA-created hyperlink always bypass the problem?

No. ActiveSheet.Hyperlinks.Add creates a hyperlink object, but Excel may still need permission to access the PDF's folder. Test the link and respond to any access prompt.