Fix Excel 2016 Crashes When Opening SharePoint or OneDrive Files
Question details
Prevent Excel 2016 from closing unexpectedly when opening a SharePoint or OneDrive workbook while another workbook is open.

- 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.
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.
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.
Open Control Panel, search for Internet Options, and select it to open Internet Properties.
Select the Security tab, choose Trusted sites, and click Sites.
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.
Click Close and OK, restart Excel, and try opening the cloud workbook while another workbook is already open.

Seek SharePoint support if the crash continues
Use this option if adding the trusted address does not help and the issue is specific to SharePoint 2010.
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.

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.




