How to Fix Microsoft Excel Has Stopped Working 2007/2010/2013/2016

Abby Haines updated on Nov 18, 2019 to File Recovery | How-to Articles

Summary

This page offers quick fixes for Microsoft Office Excel has stopped working error and tells how to recover unsaved excel document using EaseUS recovery software. Try it when Microsoft Excel 2007, 2010, 2013, 2016 or other versions crash, hang, freeze and stop working.

PAGE CONTENT:
Part 1. Fix "Microsoft Excel has stopped working" error
Part 2. Recover deleted Excel with a file recovery tool

Microsoft Excel Has Stopped Working When Saving

"Last night, when I finished working on a complex workbook and tried to save it, Windows reported that 'Microsoft Excel has stopped working' and didn't allow any operation on the document. What's worse was that I hadn’t saved my document yet. How could I solve this issue and recover my unsaved file? I'm using Microsoft Excel 2016."

Thanks to Microsoft Excel, we can deal with almost all the data relevant work, whether simple or complex data processing. Most of the time, Microsoft Excel runs smoothly and flawlessly. However, sometimes, loathsome and unspecific errors can make it down and stop work properly. On this page, we will focus on Microsoft Excel has stopped working when saving and discuss the solutions.

Microsoft Excel has stopped working

Part 1. 7 Useful Solutions to Microsoft Excel Has Stopped Working

Microsoft Excel has stopped working when saving may result from many matters, like lots of details and contents contained in Excel, the file is generated by a third-party application, add-ins interference, outdated Excel version, and more. However, whatever the reason might be, learn how to get rid of this error now.  

1. Open MS Excel in Safe Mode 

Press Windows+ R to open the Run option. Type excel.exe /safe and click "OK" to open the MS Excel in the safe mode. You can see if the software still crashes. This will help if an add-in or another program is causing Excel to stop working.

Microsoft excel has stopped working - run Excel in safe mode

2. Disable Problematic Add-ins

Step 1. Opening Excel in safe mode, click "File" > "Options" > "Add-ins". Select "COM Add-ins", and click "Go".

Step 2. You can try to disable the add-ins one by one and check if the problem has been resolved. If you have added an add-in recently, you can try to remove it first, and see if Excel works correctly after that.

Microsoft excel has stopped working - disable add-ins

3. Check for Antivirus and Other Program Conflicts

The antivirus or other program conflicts can cause the Excel has stopped working error. So here, try to end antivirus as well as the running applications to see if the issue is removed. Besides, it is recommended that you check whether your anti-virus software is up to date or not.

4. Change Default Printer

When you open an Excel document, it attempts to communicate with the printer. If that communication fails, Excel might crash and stop working. In this case, you can troubleshoot by changing the default printer.

Go to the Control Panel > click on "Devices and Printers" > set "Microsoft XPS Document Writer" as the default printer. Once done, try to open Excel again, and your problem may be resolved.

Microsoft excel has stopped working - change default printer

5. Repair Microsoft Office

Step 1. Go to the "Control panel" > choose "Programs and Features". Find Microsoft Office in the list, right-click it and click the "Change" button.

Step 2. When you click on the Change option, then an office window appears on the screen. Select "Quick Repair" > click on the "Repair" button. Wait for the process to finish.

Microsoft excel has stopped working - repair office

6. Recompile Macros

You can check for the macros as some users have reported that problematic macros can make Excel stop working.

If the Developer tool is not in the menu bar, you can add it to the menu bar as follows.

Start Excel > click on "File" > "Options" > "Customize Ribbon" > check "Developer" in the Main Tabs list.

Microsoft excel has stopped working - add Excel developer

Step 1. Launch Excel and click on "Developer" > "Visual Basic". Go to "Tools" > "Options".

Step 2. In the Options window, switch to the "General" tab, clear "Compile on Demand".

Microsoft excel has stopped working - recompile macros

Step 3. In the "Project" navigation pane, right-click "Module" and select ‘Insert’ to insert a new module. Then, save your spreadsheet and close Excel. Then, next time you use macros, you shouldn't encounter the Microsoft Excel stops working error.

7. Keep Microsoft Excel Updated 

If your Microsoft Office installation is outdated, you’ll probably meet applications working issues, like Excel stops working here, Word not responding, Word keeps crashing when saving, etc. You can possibly resolve this issue by installing the latest MS Office updates.

Step 1. Open any Office app, Word or Excel. Go to "File" > "Account".

Step 2. Under Product Information, choose "Update Options" > "Update Now".  

Microsoft excel has stopped working - update office

Conclusions

We've covered all the common solutions to Excel stopped working error in this article, and you can try them one by one to resolve the problem. But none of these measures is 100% effective. If you lose your Excel unsaved unluckily, you can resort to the AutoRecovery feature to get back the lost Excel file.

Step 1. Start Microsoft Excel application, click "File" > "Recent".

Step 2. Click "Recover Unsaved Workbooks" and choose the unsaved Excel.

Step 3. Click the "Open" button. Then click "Save As" and save this document into any other safe place.

Microsoft excel has stopped working - recover unsaved Excel

Part 2. Extra Guide: How to Recover Deleted Excel Files

Other than losing an unsaved Excel document, another hot topic is accidentally deleting saved documents. You may lose the saved Excel file by accidental deletion, hard drive formatting, emptying recycle bin, partition loss, virus attack, and more. Under this circumstance, you need a file recovery tool to help you restore lost files.

EaseUS Data Recovery Wizard is a world-wild trusted data recovery program that enables you to restore lost documents, graphics, videos, audio, email, and other files.

Now, download this capable tool to recover deleted Excel file within only three steps. It even allows you to recover files from emptied recycle bin.

Step 1. Specify a location.

Run EaseUS Data Recovery Software. Choose the drive X: or perhaps a specific folder on Desktop or somewhere else where you lost the excel files, and then click "Scan".

select a location and click scan

Step 2. Scan for data.

During the scan, you'll see more and more data showing up very quickly in the "Deleted files" result. That's part of what the software has found and displayed. To quickly find the Excel files in the massive data in the scan results, click on the "Filter" on the top area and choose "Documents". Or, search .xls or .xlsx in the Search box. 

scan excel files

Step 3. Preview and recover.

You can double click on a file to preview its integrity. Finally, select the desired files and click "Recover".

preview and recover excel files
 
 

100% of people found this article helpful.

 

Frequently Asked Questions

1. Why choose EaseUS Data Recovery Wizard?

"EaseUS Data Recovery Wizard is the best we've seen. It's far from perfect, partly because today's advanced disk technology makes data-recovery more difficult than it was with the simpler technology of the past, but it's fast and efficient..."PCMag

"The first thing you'll notice about EaseUS Data Recovery Wizard Pro is that its interface is very clear and uncluttered, with only a small collection of self-explanatory controls. You won't find lots of extra options hidden in a system of hidden menus, either; what you see really is what you get."techradar

"Recover lost files, even after deleting a partition or formatting your drive."Macworld

2. Why cannot I recover 2GB data for free?

It is recommended to check the version installed is Free or Trial because they are different versions.

Trial has data preview function but cannot save any files, while the Free version enables to recover 2 GB files. The default free space is 500 MB and you may share the product on social media to get another 1.5 GB.

3. Why cannot the recovered files be opened?

A file is saved as 2 parts on the storage device: directory info (which is comprised by file name, time stamp and size info, etc.) and data content.

If the files with original file names and folder structures cannot be opened, one possible reason is the corrupted directory info. There is still a chance to recover the data content with the RAW Recovery method in our software.

4. Why isn't it suggested to recover the files back to the original drive?

The storage structure of the lost files would be altered or damaged by any changes on the drive. If you save the recovered files back to the same drive, the original data structures and data content would be corrupted or overwritten, which causes permanent data loss. So you should prepare another disk to save the files.

5. How can I check whether my data is recoverable or not before purchase?

The Free version helps you save 2GB files to better verify the recovery quality of our product before purchase.

6. How long does it take to scan the drive?

It strongly depends on the capacity of your hard drive and the performance of your computer. As reference,most drive recoveries can be completed in around 10 to 12 hours for a 1-TB healthy hard drive in general conditions.

About Data Recovery Wizard

It's super easy to recover 250+ types of files after deletion, disk formatting and virus infection. Click the links and compare the difference of each version.