File Cannot Open

Fix an Excel Hyperlink That Hangs on a Windows Shortcut

Anum MushtaqAnum Mushtaq Nov 14, 2026 868 views

Question details

The user needs an Excel hyperlink to open another workbook without hanging.

Fix an Excel Hyperlink That Hangs on a Windows Shortcut
Product
Microsoft Excel
Device & OS
Windows
Scenario
An Excel HYPERLINK formula points to a Windows shortcut for another Excel workbook.
Observed behavior
The link hangs when it points to the workbook shortcut, although shortcuts to text and PDF files open.
Before you start

Locate the destination workbook and confirm that you can open it directly in Excel. Check the shortcut's Properties to find its target path if needed.

Solution 1Recommended

Link directly to the destination workbook

Use the XLSX file path instead of the Windows shortcut to avoid relying on the .lnk file.

1
Find the target path

In File Explorer, right-click the .lnk shortcut, select Properties, and check the Target field for the workbook's location.

2
Edit the formula

In Excel, select the cell with the hyperlink and replace the shortcut path in the formula with the workbook path, for example: =HYPERLINK("C:\user\example.xlsx","Open workbook"). Use a semicolon instead of a comma if your Excel regional settings require it.

3
Test the link

Press Enter, then click the hyperlink cell and check whether the destination workbook opens.

Link directly to the destination workbook
If the direct link still hangs: Confirm the path is accessible and try the workbook and external link checks below.
Free Microsoft Office alternative

Work with Hyperlinked Spreadsheets in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface and Excel format support for an easier transition. You can work with spreadsheet hyperlinks in WPS Spreadsheets, although it does not fix Microsoft Excel's shortcut behavior.

Work with hyperlinks to other spreadsheet filesOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interface for easier migrationGet a free, lightweight office suite
QA img-9

Frequently Asked Questions

Why should I link to the XLSX file instead of the .lnk shortcut?

A direct XLSX path avoids the Windows shortcut layer that may be involved in the hang. Replace the .lnk path in the HYPERLINK formula with the destination workbook's path and test it.

How do I find the workbook behind a Windows shortcut?

In File Explorer, right-click the shortcut and select Properties. Check the Target field for the destination path.

What if the direct workbook link also hangs?

Open both workbooks in Excel and test the hyperlink again. If the destination has external workbook links, try opening it without updating them and review the Trust Center settings.

Should I enable all external content in Excel?

No. Review File > Options > Trust Center > Trust Center Settings > External Content and allow external content only when you trust its source. These settings may not affect the hyperlink itself.