Office Apps Crashing

Fix Excel 2016 Crashes When Opening SharePoint or OneDrive Files

Huda QurayshiHuda Qurayshi Nov 22, 2026 868 views

Question details

Prevent Excel 2016 from closing unexpectedly when opening a SharePoint or OneDrive workbook while another workbook is open.

Fix Excel 2016 Crashes When Opening SharePoint or OneDrive Files
Product
Microsoft Excel 2016, SharePoint 2010, and OneDrive
Device & OS
not provided
Scenario
The user opens a cloud-hosted workbook in Excel 2016 while another workbook is already open.
Observed behavior
Excel closes unexpectedly when opening SharePoint 2010 or OneDrive files, but local workbooks open normally despite repairs, reinstallation, compatibility changes, and antivirus removal.
Before you start

Identify the SharePoint site address or OneDrive domain used to open the workbook. Confirm that the address belongs to an organization or service you trust before changing its security zone.

Solution 1Recommended

Add the SharePoint or OneDrive address to Trusted Sites

Use this security-zone check when Excel crashes on cloud-hosted workbooks but opens local files normally.

1
Open Internet Properties

Open Control Panel, search for Internet Options, and select it to open Internet Properties.

2
Open Trusted Sites

Select the Security tab, choose Trusted sites, and click Sites.

3
Add the trusted address

Enter the trusted SharePoint site address or OneDrive domain in the website field and click Add. Use an HTTPS address when the dialog requires server verification.

4
Test the workbook

Click Close and OK, restart Excel, and try opening the cloud workbook while another workbook is already open.

Add the SharePoint or OneDrive address to Trusted Sites
Use trusted addresses only: Trusted Sites uses less restrictive security settings than the Internet zone. If the setting is managed by your organization or you are unsure which address to add, contact your administrator.
Free Microsoft Office alternative

Work with Excel workbooks in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks in WPS Spreadsheets for an easier transition, although it does not fix Excel's SharePoint or OneDrive crash.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel formats such as XLS and XLSXUse WPS Spreadsheets as an alternative for working with compatible workbooksFree and lightweight for an easier move from Microsoft Office
QA img-9

Frequently Asked Questions

Where do I find the Trusted Sites setting?

Open Control Panel and select Internet Options. On the Security tab, select Trusted sites and then click Sites.

Which SharePoint or OneDrive address should I add?

Add the site address or domain you use to access the affected workbook, and only if you trust it. Ask your administrator if you are unsure of the correct address.

What if Excel still crashes after I add the site?

Restart Excel and test the workbook again. If the issue continues and is specific to SharePoint 2010, contact your SharePoint administrator or ask in a SharePoint support forum.

Will adding a site to Trusted Sites fix every Excel crash?

No. It is a troubleshooting step for this cloud-file scenario, not a guaranteed fix for every Excel crash. Test the same workbook-opening sequence after making the change.