Fix an Excel Hyperlink That Hangs on a Windows Shortcut
Question details
The user needs an Excel hyperlink to open another workbook without hanging.

- 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.
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.
Link directly to the destination workbook
Use the XLSX file path instead of the Windows shortcut to avoid relying on the .lnk file.
In File Explorer, right-click the .lnk shortcut, select Properties, and check the Target field for the workbook's location.
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.
Press Enter, then click the hyperlink cell and check whether the destination workbook opens.

Test with both workbooks open and check link settings
Use this approach if a direct hyperlink still hangs or you suspect the destination workbook's external links are involved.
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.

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.




