File Cannot Open

How to Open an Offline Excel File from an Online Workbook

Natalie TaylorNatalie Taylor Oct 21, 2026 868 views

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.

How to Open an Offline Excel File from an Online Workbook
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.
Before you start

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.

Solution 1Recommended

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.

1
Access Library Settings

Navigate to your SharePoint library, click the Settings (gear) icon in the top right, and select Library settings.

2
Open Advanced Settings

Click on More library settings, and then select Advanced settings from the menu.

3
Change Default Open Behavior

Scroll down to the 'Default open behavior for browser-enabled documents' section and select the 'Open in the client application' radio button.

4
Save Changes

Click the OK button at the bottom of the page to apply the settings.

Configure SharePoint Library to Open in Client Application
Applies to All Users: Note that changing this setting at the library level will change the default document opening behavior for all users accessing files in that specific SharePoint library.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS Office website and click the free download button.
  2. 2. Install the Software: Run the installer and follow the quick on-screen prompts to set up the software.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheets to immediately start working with your local and network files without web browser restrictions.
Excellent compatibility with Microsoft Office formats, including .xlsx, .xls, and .csv files.Manage offline local files and cloud documents seamlessly within a single, unified interface.Completely free to use with a lightweight footprint that won't slow down your computer.Familiar user interface ensuring zero learning curve for switching users.
microsoft office alternative - wps office

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.