Excel hyperlinks open workbook as read-only – here's the fix

You click a hyperlink in Excel, and the same workbook opens in read-only mode

Here's the exact scenario: you're working in a shared workbook saved on a network drive (like \\server\share\report.xlsx). You click a hyperlink inside that file pointing to itself — maybe a table of contents link — and Excel opens a second, read-only copy of the same workbook. You see "[Read-Only]" in the title bar. This happens most often with UNC paths, mapped drives, or when the workbook is opened from SharePoint or OneDrive synced folders.

Root cause: Excel treats the hyperlink path and the current workbook path as different locations

Even though both point to the same file, Excel sees them as separate. When you click a hyperlink, Excel opens the file fresh — and because the workbook is already open (from the same source), it opens the new copy in read-only. This isn't a bug. It's Excel's file-locking behavior by design. The real culprit is almost always a mismatch between the hyperlink's target path and the workbook's current open path. For example, the hyperlink uses \\server\share\report.xlsx but the workbook was opened from Z:\report.xlsx (a mapped drive). Or the hyperlink includes the full UNC path while Excel sees a shortcut or a different drive letter.

Fix it in these steps

1. Check the hyperlink's target path

Right-click the hyperlink, choose Edit Hyperlink. Look at the Address field. Compare it to the actual path of the open workbook. If they don't match exactly (including drive letter vs UNC, trailing backslashes, or case sensitivity), that's your problem. The fix: update the hyperlink to match the exact path Excel is using. Open the workbook, go to File > Info > Copy Path (or right-click the title bar in older Excel) and paste that path into the hyperlink's Address field.

2. Use relative paths instead of absolute paths

If the workbook and its hyperlinks live on the same drive, switch to relative paths. In the Edit Hyperlink dialog, remove the full path and just type the filename (e.g., report.xlsx) if the hyperlink points to itself. Excel resolves relative paths based on the current workbook's location. This avoids the path mismatch issue entirely.

3. Turn off the read-only recommendation for network files

This is a registry tweak for Excel 2016, 2019, 2021, and Microsoft 365. It changes the default behavior when opening files from untrusted locations.

Registry path: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Security
Value name: FileOpenBlock
Value type: DWORD
Value data: 0 (or delete the value)

If that key doesn't exist, you don't have the block enabled. Don't create it. This fix only applies if you're seeing "Protected View" or "Read-Only" on every file from a network drive, not just hyperlinks.

4. Clear the file's read-only attribute

This is basic but easy to miss. Right-click the file in Explorer, go to Properties, uncheck Read-only. If the file is on a network share, check with your admin — some shares force read-only for everyone. That's a server-side setting, and no Excel tweak will fix it.

5. Open the workbook from the same path the hyperlink uses

Temporary workaround: close the workbook, then open it using the exact path from the hyperlink. If the hyperlink says \\server\share\report.xlsx, open it via Start > Run (Win+R) and paste that path. Then click the hyperlink. If it no longer opens read-only, you've confirmed the root cause is a path mismatch.

What to check if it still fails

• Check for workbook sharing. Go to Review > Share Workbook (old Excel) or Review > Track Changes (newer). If sharing is on, Excel locks the file for everyone else. Hyperlinks will still open read-only. Turn off sharing, then test.
• Check add-ins. Third-party add-ins can override how hyperlinks behave. Disable all add-ins (File > Options > Add-ins > Go > Uncheck all). Restart Excel. If the issue goes away, re-enable one at a time to find the culprit.
• Check the file's location. OneDrive and SharePoint sync folders can cause this if the hyperlink points to the local sync folder but the file is also open from the cloud. Open the file from the OneDrive web interface instead of the local folder.
• Check if the file is already open by someone else. Network share files locked by another user will open read-only regardless of hyperlink settings. Use the built-in file lock checker (if your admin provides one) or ask colleagues.

If none of this works, the file might be corrupted. Save a copy to a local drive, rename it, and rebuild your hyperlinks from scratch. That's rare, but I've seen it twice in 14 years.