File Sharing Problems

How to Fix Excel SharePoint Links Downloading Instead of Opening

Anum MushtaqAnum Mushtaq Nov 10, 2026 869 views

Question details

Users clicking links to other workbooks stored in SharePoint from Excel for the web find that the linked files are downloading instead of opening in a new browser tab.

How to Fix Excel SharePoint Links Downloading Instead of Opening
Product
Microsoft Excel for the Web, SharePoint
Device & OS
not provided
Scenario
Clicking hyperlinks within an Excel online workbook that point to other SharePoint-hosted Excel files.
Observed behavior
The linked Excel files are forcibly downloaded to the local machine rather than opening in a new browser tab, and URL parameters like ?web=1 fail to resolve the issue.
Before you start

Understand that this is a recent behavior change implemented by Microsoft for security and file-isolation purposes, rather than a workbook corruption or user error. There is currently no user-side setting to restore the old open-in-tab behavior.

Solution 1Recommended

Use SharePoint Item Page Links

Modify your hyperlinks to point to the SharePoint item page view rather than the direct file URL to prevent the browser from automatically downloading the file.

Because direct file links now trigger an automatic download in Excel for the web, directing the user to the SharePoint folder view where the file resides bypasses this restriction. This requires one extra click from the user but successfully prevents the forced download.

1
Navigate to the SharePoint folder

Open your web browser and navigate to the SharePoint document library where the target Excel file is stored.

2
Copy the item page URL

Instead of copying the direct link to the file, copy the URL of the SharePoint page from your browser's address bar (it typically includes 'AllItems.aspx?id=').

3
Edit the Excel hyperlink

Open your main workbook in Excel for the web, right-click the cell containing the hyperlink, and select 'Edit Hyperlink'.

4
Paste the new link

Paste the copied SharePoint item page URL into the address field and click 'OK' to save your changes.

User Experience: When users click this updated link, it will open the SharePoint folder in a new tab, requiring them to click the specific file once more to open it in the web editor.
Free Microsoft Office alternative

Experience Seamless Cloud Collaboration with WPS Office

If Microsoft Excel and SharePoint restrictions are disrupting your team's workflow, consider switching to WPS Office. It offers a lightweight, highly compatible spreadsheet tool with flexible cloud document sharing that avoids forced download issues.

  1. 1. Download WPS Office: Visit the official WPS Office website and download the free installer for your device.
  2. 2. Install the Software: Run the downloaded installation file and follow the simple on-screen instructions to set up WPS Office.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Microsoft Excel files directly, preserving all your data and formatting perfectly.
Fully compatible with Microsoft Excel (.xlsx, .xls) formatsSeamlessly open and edit cloud documents without forced downloadsFree, lightweight, and easy to use across multiple operating systemsBuilt-in cloud collaboration and effortless file sharing
microsoft office alternative - wps office

Frequently Asked Questions

Why do my SharePoint links in Excel suddenly download files?

Microsoft recently updated the file-handling logic for Excel for the web and SharePoint. This change prioritizes security, cross-application isolation, and shared logic with OneDrive, which defaults to downloading direct file links instead of opening them in a new tab.

Can I fix the download issue by adding ?web=1 to the URL?

No, URL parameters such as ?web=1 or ?web=1&action=default are currently ignored by Excel for the web when handling these specific hyperlinks.

Is there a setting in Microsoft 365 to restore the old hyperlink behavior?

Currently, there are no tenant-level settings, registry changes, or user preferences available that can force Excel for the web to revert to the old behavior of opening workbook links in a new browser tab.

Will VBA macros or Office Scripts fix the SharePoint link issue?

No, there is currently no reliable VBA procedure, Office Script, or formula that overrides this new download behavior enforced by Excel for the web.