How to Open an Offline Excel File from an Online Workbook
Question details
The user wants to click a standard worksheet link within an online Excel workbook to directly open a local or shared-drive offline Excel file.

- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- A user is working in Excel for the web and clicks a hyperlink intended to open another Excel file located on a local hard drive or a local network shared drive.
- Observed behavior
- Excel for the web cannot directly open local or shared-drive workbooks through a standard hyperlink due to web browser security limitations.
Ensure you have the desktop version of Excel installed on your computer and verify that you have administrative permissions to modify the SharePoint library settings.
Configure SharePoint Library to Open in Client Application
Change your SharePoint library settings so that browser-enabled documents automatically open in the desktop application, allowing local offline links to function properly.
Because web browsers restrict direct access to local files, the best workaround is to configure your SharePoint library to always open files in the desktop client by default.
Navigate to your SharePoint library, click the Settings (gear) icon in the top right, and select Library settings.
Click on More library settings, and then select Advanced settings from the menu.
Scroll down to the 'Default open behavior for browser-enabled documents' section and select the 'Open in the client application' radio button.
Click the OK button at the bottom of the page to apply the settings.

Manually Open the Online File in the Desktop App
If you do not have permission to change SharePoint settings, you can manually switch your active session from the web browser to the desktop application.
Manage Local and Cloud Files Seamlessly with WPS Office
If you are frustrated by the limitations of web-based spreadsheet applications, WPS Office provides a powerful, lightweight desktop alternative. It seamlessly bridges the gap between cloud storage and local files without restricting your workflow.
- 1. Download WPS Office: Visit the official WPS Office website and click the free download button.
- 2. Install the Software: Run the installer and follow the quick on-screen prompts to set up the software.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets to immediately start working with your local and network files without web browser restrictions.

Frequently Asked Questions
Why can't I open a local drive link directly from Excel for the web?
Modern web browsers operate in a secure 'sandbox' environment that actively prevents web applications like Excel for the web from executing or directly accessing files stored on your local computer or private network drives.
Will changing the SharePoint default open behavior affect other people on my team?
Yes. When you change the SharePoint library settings to 'Open in the client application', that setting becomes the default behavior for everyone who attempts to open browser-enabled documents from that specific library.
What should I do if the 'Open in Desktop App' button is missing or grayed out?
If the button is missing or disabled, ensure that you have a compatible desktop version of Microsoft Office installed on your device, and verify that your browser is not blocking the application launcher prompts.




