Fix Excel 2016 Crashing When Opening SharePoint Mapped Drive Files
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.
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.
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.
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.
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.
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.
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.
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.

Copy the workbook contents into a new Excel file
Try a new workbook if connection and Safe Mode checks do not resolve the issue, to help rule out workbook corruption.
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.

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.




