Office Apps Crashing

Fix Excel 2016 Crashing When Opening SharePoint Mapped Drive Files

Muhammad TalhaMuhammad Talha Nov 22, 2026 868 views

Question details

The user needs Excel 2016 to open affected workbooks from a mapped SharePoint drive without closing.

Product
Microsoft Excel 2016 and SharePoint
Device & OS
not provided
Scenario
Opening certain Excel workbooks from a mapped SharePoint drive.
Observed behavior
Excel closes after reaching the splash screen. The workbook opens locally, and renaming its folder temporarily resolves the issue.
Before you start

Identify an affected workbook and confirm that it opens from a local folder. Sign in to the relevant SharePoint site in a browser and check that you can access the workbook there.

Solution 1Recommended

Check the SharePoint connection and test Excel in Safe Mode

Use these checks to narrow down whether the mapped connection or an Excel add-in is contributing to the crash.

1
Test access through SharePoint

Open the SharePoint site in your browser, navigate to the affected workbook, and try opening it in Excel from the document library. Compare the result with opening it from the mapped drive.

2
Troubleshoot the mapped connection

Check the mapped drive in File Explorer and confirm that you are signed in to the correct SharePoint account. Consult Microsoft's guidance for troubleshooting SharePoint Online connections and mapped drives, or ask your administrator to check the connection and permissions.

3
Open Excel in Safe Mode

On Windows, press Windows+R, enter excel /safe, and select OK. In Excel, select File > Open and try the affected workbook from the mapped drive.

4
Check add-ins if Safe Mode works

In Excel, select File > Options > Add-ins. Choose COM Add-ins next to Manage, select Go, and disable add-ins for testing. Restart Excel normally and re-enable them one at a time to identify a possible cause.

5
Check Office and Windows versions

In Excel, select File > Account to check the Office version and available update options. On Windows, press Windows+R, enter winver, and select OK to check the Windows version; share both versions with your administrator if the issue continues.

Check the SharePoint connection and test Excel in Safe Mode
A folder rename may be temporary: Renaming the SharePoint folder may allow the workbook to open temporarily, but it does not establish the cause of the crash.
Free Microsoft Office alternative

Open Excel Workbooks with WPS Spreadsheet

WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Excel formats, making it easy to work with existing files. It does not repair Excel or a SharePoint mapped-drive connection.

Open and edit local spreadsheet copies in WPS SpreadsheetCompatible with common Microsoft Excel formats, including XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does the workbook open locally but crash from the mapped drive?

The difference suggests that the SharePoint connection or file path may be involved, but it does not confirm the cause. Try opening the workbook from the SharePoint document library in a browser and compare the result.

How do I start Excel 2016 in Safe Mode?

On Windows, press Windows+R, enter excel /safe, and select OK. Then use File > Open to test the affected workbook.

What should I do if the workbook opens in Safe Mode?

Check add-ins under File > Options > Add-ins. Select COM Add-ins next to Manage, choose Go, and disable them for testing before restarting Excel normally.

Will copying sheets to a new workbook preserve everything?

Not necessarily. After using File > New to create a workbook and copying the contents, check formulas, external links, formatting, charts, and macros before relying on the new file.