How to Fix Excel SharePoint Links Downloading Instead of Opening
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.

- 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.
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.
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.
Open your web browser and navigate to the SharePoint document library where the target Excel file is stored.
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=').
Open your main workbook in Excel for the web, right-click the cell containing the hyperlink, and select 'Edit Hyperlink'.
Paste the copied SharePoint item page URL into the address field and click 'OK' to save your changes.
Create a SharePoint Hub Page with File Viewer
Embed the target workbooks in a dedicated SharePoint site page using the File Viewer web part, and link to this specific page from Excel.
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. Download WPS Office: Visit the official WPS Office website and download the free installer for your device.
- 2. Install the Software: Run the downloaded installation file and follow the simple on-screen instructions to set up WPS Office.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Microsoft Excel files directly, preserving all your data and formatting perfectly.

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.




