Fix Excel for Mac Hyperlink Formulas That Cannot Open Local PDFs
Question details
The user needs to open local PDF files from HYPERLINK formulas in a newer version of Excel for Mac.

- 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.
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.
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.
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.
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.
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.

Create a PDF hyperlink with VBA in Excel for Mac
Try a VBA-created hyperlink when you need to add links programmatically and a manually inserted link works.
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.

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.




