Forum Discussion
Hyperlinks not working on Macbook air
To resolve the hyperlink issue in Excel on your MacBook Air, follow these structured steps. The problem likely stems from macOS security permissions or Excel-specific settings:
Step-by-Step Solution
1. Check File/Folder Permissions
- Right-click the PDF file or its containing folder → Get Info.
- Under Sharing & Permissions, ensure your user account has Read & Write access.
- If locked, click the lock icon (bottom-right), authenticate, and adjust permissions.
2. Grant Excel Full Disk Access
- Go to Apple Menu → System Settings → Privacy & Security → Full Disk Access.
- Ensure Microsoft Excel is listed and checked. If not:
- Click + → Navigate to /Applications/Microsoft Excel.app → Add it.
- Restart Excel after granting access.
3. Manually Insert Hyperlinks
Instead of using the "Insert Link" tool, use the formula bar:
- Right-click the PDF in Finder → Copy "File.pdf" as Pathname.
- In Excel, select a cell and type:
- =HYPERLINK("Paste/Copied/Path/Here.pdf", "Display Text")
- Replace Paste/Copied/Path/Here.pdf with the actual path.
4. Reset Excel Preferences
- Quit Excel.
- Open Finder → Press Command + Shift + G → Paste:
~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/ - Delete com.microsoft.Excel.plist (backup first if needed).
- Empty Trash and restart Excel.
5. Clear Excel Cache
- In Finder, navigate to:
~/Library/Containers/com.microsoft.Excel/Data/Library/Caches/ - Delete all files in this folder.
- Restart Excel.
6. Temporarily Disable Security Prompts (Testing Only)
- Go to System Settings → Privacy & Security → Security.
- Set Allow apps downloaded from to App Store (most restrictive).
- Revert to App Store and identified developers after testing.
- Manually open the PDF once via Finder to "trust" it, then retry the hyperlink.
7. Update or Reinstall Excel
- Update Excel: Open Excel → Help → Check for Updates.
- Reinstall Excel if issues persist:
Uninstall Excel via Finder → Applications.
Delete residual files:
~/Library/Containers/com.microsoft.Excel/
Download the latest version from the Mac App Store.
If the issue persists after these steps, consider testing with a PDF in your Downloads folder (a trusted location) to rule out folder-specific restrictions.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.