If you use Microsoft Excel a lot, then you want to make sure it works smoothly all the time and keeps your data safe. However, errors like "Microsoft Excel has stopped working" can occur at any time no matter how careful you are. Fortunately, solutions are available.
Errors like "Microsoft Excel has stopped working" can often occur if the latest Windows and Office updates are not installed. So, to make sure Excel keeps working without issues, it is highly recommended that you install the latest version as well as any updates that you may have missed on.
The functionality of Microsoft Excel can be enhanced by installing various Add-ins. However, sometimes add-ins can get corrupted and disrupt the functionality of Excel. Then you'll see the "Microsoft Excel has stopped working" message. In that case, you will need to disable faulty add-ins.
Step 1. Launch Excel on your computer.
Step 2. Navigate to File Menu > Excel Options > Add-ins. It will be shown on the left-hand side. In that section, a list of Active Application Add-ins will be displayed. You will see every add-in with its name, location, and type in that list.
Step 3. Let's say X add-in is faulty and you need to disable it. To do this, navigate to the Manage option and click on X add-in > GO.
Step 4. A dialog box for the X add-in will appear on the screen. There, uncheck the first option and click OK. The add-in will be disabled and you will be able to use Excel without issues.
Since Excel is a part of Microsoft Office, any confliction with MS Office can create issues causing Excel to suddenly stop working. If that is the case, then you will need to repair MS Office to fix the issue.
Follow these instructions:
Step 1. On your PC, navigate to Control Panel and click on the Microsoft Office from the list of installed programs.
Step 2. Next, launch Command Prompt and input appwiz.cpl, then press Enter.
Step 3. Now click on the Change option. Now you may see a window appearing on the screen. From that window, click on Quick Repair option and then click on the Repair button. The repairing process will begin.
Step 4. When the repairing process is complete, you will see a confirmation message. Click on the Close button to close the notification and then open an Excel file. The file should now be opened without issues.
"Microsoft Excel has stopped working" error can also occur due to problematic Macros. If that is the cause behind the error, then you will need to tweak a few settings to make sure that using Macros doesn't crash Microsoft Excel.
1. Launch Microsoft Excel on your computer.
2. Once it is launched, navigate to Developer > Visual Basic.
3. Next, navigate to Tools > Options. In that section, find and clear the 'Compile on Demand' option. It will be shown under the General tab.
4. Now in the Project navigation pane, find and right-click on the Module option and then click on the 'Insert' button in order to insert a new module.
5. Now save the spreadsheet and close the application. If problematic Macros were indeed causing Microsoft Excel to stop working, then the issue should be fixed now and you will be able to use Macros without causing Excel to crash.
Just like your Windows PC, you can start Microsoft Excel in Safe Mode for debugging purposes. If Excel is constantly crashing and displaying "Microsoft Excel has stopped working" error, then it would be a good idea to launch it in Safe Mode to see if it works without issues. If Excel does not crash when launched in Safe Mode, then you can confirm that the issues are caused by certain factors e.g. add-ins, external files, software conflicts, etc.
Follow these instructions to launch Excel in Safe Mode:
1. Launch Command Prompt on your Windows PC.
2. In the CMD window, input excel.exe/safe and press Enter. This will launch Microsoft Excel in safe mode. You can then open an Excel file and see if the software still crashes.
3. Alternatively, you can use the ctrl button and click on open Excel file option. This will also allow you to use Excel in safe mode.
Recovering unsaved Excel files is possible thanks to professional data recovery tools such as iMyFone AnyRecover. There are several powerful recovery modes of AnyRecover and the tool also allows you to preview the unsaved Excel files before recovery.
Recover unsaved Excel files when your Microsoft Excel stop working.
Recover Excel files from any type of storage device, such as hard drive, SD card, external hard drive, etc.
Except Excel files, iMyFone AnyRecover can also recover images, photos, Word document, and 1000 formats more.
Won't overwrite the existing versions of files, 100% safe to use.
By Simon Marcus , to Document Recovery
Posted on Aug 16, 2019 ( Updated: May 29, 2020 )