How to Open Excel Hyperlinks in the Desktop App Instead of Web
Question details
The user needs to configure Microsoft Excel so that clicking a hyperlink to another workbook opens the file directly in the desktop application rather than launching Excel for the Web in a browser.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Clicking a hyperlink within an Excel spreadsheet that links to another local or synced workbook.
- Observed behavior
- The linked workbook opens in a web browser using Excel for the Web, bypassing the local Excel desktop application.
Ensure that the Microsoft Excel desktop application is fully installed on your computer and that the linked workbook still exists in the specified destination folder.
Change the Hyperlink Path to a Local Drive
Update the hyperlink address from a web URL (HTTP/HTTPS) to a local file path so the system recognizes it as a local file instead of a web page.
When workbooks are synced using OneDrive or SharePoint, Excel sometimes automatically converts local file paths into web URLs (e.g., https://d.docs.live.net/...). When clicked, your system defaults to opening web URLs in a browser. Changing the path back to your local C: drive directory forces the file to open on the desktop.
Right-click the cell containing the problematic hyperlink and select 'Edit Hyperlink' from the context menu.
Look at the 'Address' box at the bottom of the dialog. If it starts with 'http://' or 'https://', this is the reason it opens in a web browser.
Use the 'Look in' file browser within the dialog to navigate to the exact folder on your computer (e.g., C:\Users\YourName\Documents), select the workbook, and click 'OK'.
Enable Desktop Link Handling in Excel Options
Use Microsoft Excel's built-in advanced settings to force supported cloud links to open within the desktop environment.
Set Excel as the Windows Default App
Verify that your Windows operating system is correctly configured to open spreadsheet files natively with the Excel application.
Manage Desktop Spreadsheets Seamlessly with WPS Office
WPS Office is a powerful, lightweight alternative that handles local file hyperlinks perfectly within its desktop environment. It bypasses frustrating browser redirects, ensuring your offline and local workflow remains entirely on your desktop.
- 1. Insert Hyperlink in WPS Spreadsheet: Open your workbook in WPS Spreadsheet, select a cell, and go to the 'Insert' tab to click 'Hyperlink'.
- 2. Select a Local Target: Choose 'Existing File or Web Page', navigate to your local document directory, select the target workbook, and click 'OK'.
- 3. Click and Open Native: Click the generated link. WPS Office will securely open the linked document immediately within its desktop tabs without launching a web browser.
Frequently Asked Questions
Why do my local Excel files suddenly open in the web browser?
This usually happens when your files are synced to cloud storage like OneDrive or SharePoint. Excel replaces the traditional local file path (C:\...) with a direct web URL. Because it's recognized as a web link, clicking it tells your computer to open it in a browser.
Can I prevent OneDrive from converting my local hyperlink paths into web URLs?
Yes, but it requires adjusting OneDrive settings. You can often stop this behavior by unchecking the 'Use Office applications to sync Office files that I open' option in the OneDrive desktop client settings.
Does this issue happen if I link to a PDF instead of an Excel file?
If you link to a local PDF file, it will typically open in your computer's default PDF viewer or browser (depending on your Windows default app settings for .pdf files). The forced web redirection primarily affects Office documents hosted on Microsoft cloud services.
I changed the Link Handling settings but links still open in the browser. What's wrong?
The 'Open supported hyperlinks in Office desktop apps' setting only works for supported Microsoft 365 environments. If you are using an older version of Excel or the link points to a third-party website, it will still open in the browser. Double-check that your hyperlink is set to a local directory path.
