Fix Excel 2016 Crashes When Multiple Workbooks Are Open
Question details
The user needs to stop Excel 2016 from crashing when multiple workbooks are open.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows (version not provided)
- Scenario
- Opening and working with multiple Excel workbooks at the same time.
- Observed behavior
- Excel 2016 crashes while multiple workbooks are open, even when the workbooks do not use macros.
Close Excel and note which workbooks were open when it crashed. After each change, reopen the same workbooks to check whether the crash persists.
Repair the Office 2016 installation
Use Office Repair first to address damaged Office program files.
Close Office apps, then open Windows Settings > Apps. Find Microsoft Office 2016 or Microsoft 365 in the installed apps list and select Modify.
Select Quick Repair > Repair. When it finishes, open Excel and test the same workbooks.
If Excel still crashes, return to Modify, select Online Repair, and follow the prompts. An internet connection is required.

Check Excel add-ins, startup files, and graphics settings
Use Safe Mode and Excel Options to isolate settings or files that may trigger a crash.
Check the Windows profile, printer driver, and software conflicts
Use these checks if repairing Office and changing Excel settings do not stop the crashes.
Work with multiple spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Excel format compatibility can make it easier to move existing files to WPS, although it does not repair Microsoft Excel itself.

Frequently Asked Questions
Can Excel 2016 crash even if my workbooks have no macros?
Yes. Add-ins, startup files, Office installation damage, printer drivers, graphics settings, or other software can cause crashes without workbook macros.
How do I start Excel 2016 in Safe Mode?
Press Windows+R, type excel /safe, and select OK. Then open the affected workbooks to see whether Excel remains stable.
Where can I find the Excel startup folder?
Press Windows+R and enter %appdata%\Microsoft\Excel\XLSTART. Also check File > Options > Advanced > General for an additional startup folder path.
What should I do if Quick Repair does not fix the crash?
Return to the Office entry in Windows Settings > Apps, select Modify, and run Online Repair. If the crash continues, test Safe Mode and the other troubleshooting steps.




