2022 FIX: Excel Keeps Crashing Windows 10 - All Too Easy to Handle | Qiling  

2022 FIX: Excel Keeps Crashing Windows 10 - All Too Easy to Handle


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 be subject to a total loss if you didn't turn on the autosave feature in Excel beforehand.

When there is a crashing problem found in Excel, it's likely to get the following error messages:

#1. Microsoft Excel has stopped working. Hang on while Windows reports the problem to Microsoft...[Cancel]

excel has stopped working

#2. Microsoft Excel is not responding.

excel is not responding

#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]

a problem caused the program to stop working properly

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:

start excel in safe mode

Method 2. Install the Lastest Updates

Updating software once got an issue is one of the general ways to rectify a certain problem. At the beginning, 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 latest update of your Excel version. Follow the guide to install an update that may help correct the crash problem.

install update for excel

Useful Tip: If you cannot open Excel right now due to a 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 to crash 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.

remove add-ins in excel to fix excel crashing problem

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 a problem related to the conditional formatting rules. Try to clear some like this:

clear conditional formatting rules to fix excel crashing

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.

You receive a "Too many different cell formats" error message in Excel

Method 7. Disable Microsoft Excel Animation

With some animation effect in Excel, that'll be fun to work. Using animation correctly can enhance the story your 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.

disable animation to fix excel crashing

Method 8. Repair MS Office

Being one of the MS Office suites, Excel keeps crashing can be hopefully fixed by repairing MS Office. It's worth trying the repair in Control Panel in Windows 10.

Press Windows +R keys and type appwiz.cpl and click OK

repair ms office to fix excel crashing

repair ms office to repair excel crashing

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 an elaborate guide on each method, including:

Excel cannot open the file Runtime error in Excel

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 AutoSave 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.

recover excel from autorecover step 1

Step 4. Click "Recover Unsaved Workbooks" and wait to let the program recover your crashed Excel document.

recover excel from autorecover step 2

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.

recover excel from autorecover step 3

Solution 2. Recover Excel File Lost from Crash with Excel File Recovery Software

The Excel workbook may disappear from its original location after experiencing several consecutive crashes. For the files, you can find nowhere after a crash, use Qiling file recovery software to scan, search and recover the loss.

Step 1. Select file types and click "Next" to start

Launch Deep Data Recovery. Select file types and click "Next" to start.

Select file types that you want to recover

Step 2. Select location and click "Scan"

Choose the drive or a specific folder on Desktop or somewhere else where you lost the excel files, and click the "Scan" button.

select the location of the Excel files

Step 3. Locate your excel files

To quickly find the Excel files from the scan results, click the "Documents" option in the left panel. Choose "Excel", and click "Preview" to check if the Excel files are the wanted ones.

recover Excel files

Step 4. Recover Excel files

Finally, select the desired Excel files and click the "Recover" button. Then, select a folder to save the Excel files to another location.

Related Articles


Is this information helpful?     

What can we do to improve this information? (Optional)
Refresh Please enter the verification code!