Table of Contents
- Best Data Recovery Software
- Video Recovery
- SD Card Recovery
- Recycle Bin Recovery
- Recover Data from USB
- Recover Deleted Emails
- Hard Drive Not Showing Up in Windows
- Recover Unsaved Word Documents
- Recover Deleted Files in Windows 10
- Recover Files from Virus Infected Hard Drive
- Best Free Photo Recovery Software
- Recover Files from Formatted Hard Drive
Excel Keeps crashing in Windows 10. Does this vexing problem annoy you? The risks are there: You cannot open an existing file if the Excel application crashes upon launching. What's worse, the workbook you're currently editing may subject to a total loss if you didn't turn on the auto save feature in Excel beforehand.
When there is a crashing problem found in Excel, it's likely to get following error messages:
#1. Microsoft Excel has stopped working. Hang on while Windows reports the problem to Microsoft...[Cancel]
#2. Excel is not responding. If you restart or close the program, it will try to recover your information. (You can choose to restart, close or wait for the program to respond)
#3. Microsoft Excel has stopped working. A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available. [Close program]
In fact, when you receive error messages that indicate your Excel has crashed, you can never wait for a solution. You can only depend on your own to seek feasible solutions online, and here the content is what you're looking for.
Method 1. Start Excel in Safe Mode
Safe mode ensures you open Excel in a clean environment without encountering certain startup programs. To open Excel in Safe Mode:
- Press and hold Ctrl while you start the Excel program (Option 1)
- Press Windows + R keys to bring up Run (Option 2)
- Type excel.exe /safe and hit Enter
Method 2. Install the Lastest Updates
Updating software once got an issue is one of the general way to rectify a certain problem. At the begining, you don't need to spend time and effort to update the operating system, which is considered as effective as well, try to fix bugs by getting the lastest update of your Excel version. Follow the guide to install an update that may help correct the crash problem.
- In Excel, open File > Account
- Under Product Information, select Update Options and click Update Now
Useful Tip: If you cannot open the Excel right now due to crash, you may open Microsoft Store and update your Office applications there.
Method 3. Check and Remove Faulty Add-ins
Unmatched and faulty add-ins will cause Excel crashing from time to time with no doubt, so it's necessary to check and remove the add-ins that are not applicable to your Excel.
- Restart Excel in normal mode and go to File> Options> Add-ins
- Choose COM Add-ins from the drop-down and click Go
- Uncheck all the checkboxes and click OK
- Restart Excel to check if the issue persists
Method 4. Remove The Process That Is Using Excel
If Excel is in use by another process, this information will be displayed in the status bar at the bottom of the Excel window. If you try to perform other actions while Excel is in use, Excel may not respond. Let the task in process finish its job before attempting other actions.
Method 5. Clear Conditional Formatting Rules
Conditional formatting is a feature that allows you to apply specific formatting to cellss. The most often used is color-based formatting for you to highlight, emphasize, or differentiate among data and information stored in a spreadsheet. If a sheet is causing Excel to freeze or crash, it might be the problem related to the conditional formatting rules. Try to clear some like this:
- Under Home, click Conditional Formatting
- Choose Clear Rules
- Select Clear Rules from Entire Sheet
- If multiple sheets adopts the rule, repeat the steps to clear them all
Method 6. Remove Cell Formatting and Styles
Similar to the conditional formatting rules, the cell formatting and styles are also prone to cause the Excel program starts malfunctioning, like freezing or crashing. To remove different cell formats and styles, you should do this way as Microsoft support taught.
Method 7. Disable Microsoft Excel Animation
With some animation effect in Excel, that'll be fun to work. Use animation correctly can enhance the story you data is telling. However, the animations usually require additional processing power and resources, which is prone to cause Excel overload. As a result, Excel crashes as animation adoption grows. To disable some excessive animations in Microsoft Excel, follow the below steps.
- Click File > Options
- Click Advanced on the left pane and uncheck the option Disable hardware graphics acceleration
- Click OK to close Excel
Method 8. Repair MS Office
Being one of the MS Office suite, Excel keeps crashing can be hopefully fixed by repairing MS Office. It's worth trying the repair in Control Panel in Windows 10.
- Open Programs and Features in Control Panel using a direct way:
Press Windows +R keys and type appwiz.cpl and click OK
- Locate Microsoft Office among the list, right click on it and choose Change
- Select Quick Repair and click the Repair button
How to Recover Data from Crashing Excel Workbook in Windows 10
Follow the previous article <How Does an Excel File Get Corrupted>that is written exclusively for repairing a corrupted Excel file with data stored in it. The article offers elaborate guide on each method, including:
- Use the Microsoft Open and Repair Tool
- Chang the file extension to a compatible one
- Restore the copy from the previous version
- Use external references to link to the corrupted Excel file
Approximately a half Excel crashing problem will cause data loss, leaving it being deleted, hidden or unsaved. Hence, it's important to know how to recover data from the Excel file that suddenly closed by a sudden crash.
Solution 1. Recover Crashed Excel File from AutoRecover
Works only for the premise that you turned on the Auto Save in Excel.
Step 1. Open a new Excel file in Windows 10 or Windows 8/7.
Step 2. Click "File" > "Open" > "Recent" option.
Step 3. Then check the recently used Excel document and find the unsaved file when Excel crashes.
Step 4. Click "Recover Unsaved Workbooks" and wait to let the program recover your crashed Excel document.
Step 5. Then a pop-up will occur, and you can open the crashed Excel file and click "Save AS" to store the Excel as a new file to a safe location on your PC.
Solution 2. Recover Excel File Lost from Crash with Excel File Recovery Software
The Excel workbook may disappear from its orignal location after experiencing several consecutive crash. For the files you can find nowhere after a crash, use EaseUS file recovery software to scan, search and recover the loss.
Step 1. Select location and click "Scan"
Choose the drive X: or a specific folder on Desktop or somewhere else where you lost the excel files, and then click "Scan".
Step 2. Locate your excel files
To quickly find the Excel files from the scan results, click on the "Filter" on the top area, choose "Excel", and click tree view on the left side. Or, search .xls or .xlsx in the Search box.
Step 3. Preview and recover
You can double click on the Excel file to preview its integrity. Finally, select the desired Excel files and click "Recover".
Was This Page Helpful?
Author Jean has been writing tech articles since she was graduated from university. She has been part of the EaseUS team for over 5 years. Her special focuses are data recovery, disk partitioning, data space optimization, data backup and Mac OS. By the way, she's an aviation fan!
EaseUS Data Recovery Wizard is a powerful system recovery software, designed to enable you to recover files you’ve deleted accidentally, potentially lost to malware or an entire hard drive partition. Read More
EaseUS Data Recovery Wizard is the best we have 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. Read More
EaseUS Data Recovery Wizard Pro has a reputation as one of the best data recovery software programs on the market. It comes with a selection of advanced features, including partition recovery, formatted drive restoration, and corrupted file repair. Read More