How to Fix Excel 2021 has Encountered a Problem
![](/images/site-logo.png)
How to Fix Excel has Encountered a Problem
While working on MS Excel, you may encounter various errors that can hamper your work and productivity. One of the errors that you may receive is ‘Microsoft Excel has encountered a problem and needs to close’.Due to this error, your Excel program may stop and asks you to recover the data from Excel file.
What are the Reasons for ‘MS Excel has Encountered a Problem’ Error?
Following are some primary causes that may result in the ‘Microsoft Excel has encountered a problem and needs to close’ error:
- Corrupt Excel File: If you try to open a corrupt or damaged Excel file, the file may not open and displays this error message.
- File not Saved Properly: If Excel files aren’t saved correctly, this error may occur when you open the file.
- Incompatible File Version: If the MS Excel application version does not support the Excel file version, the file may not open and throws the error.
- Issues with MS Office/MS Excel Installation: This error can sometimes be caused due to damaged MS Office/MS Excel installation.
How to Fix ‘MS Excel has Encountered a Problem’ Error?
You can resolve the error by using the following methods:
1. Try to Open Excel in Safe Mode
Open the Excel application in safe mode and then try to open the Excel file. This will help you find out if the problem is caused by some incompatible add-ins. The steps are as follows:
- Hold Windows + R keys together to launch the Run dialog box.
- Type Excel /safe in the search box and hit Enter.
- If your Excel application opens in safe mode, it means that the issue is caused due to incompatible or faulty add-ins. In such a case, you need to disable the add-ins:
- Go to the File menu and click the Options menu. Further, choose the Add-ins option.
- Now, choose the Go button at the bottom of the Excel Options window.
- A list of available add-ins appears.
- Now, uncheck the boxes against the add-ins.
2. Disable Macros Using the Trust Center Settings
Sometimes, the Macros prevent Excel from managing the files. You can disable the Macros to resolve the issue. Follow these steps:
- Launch your MS Excel application.
- Now, go to File > Options > Trust Center.
- Further, click the Trust Center Settings.
- Now, navigate to the Macro Settings option.
- Herein, select the ‘Disable all macros with notification’ radio button. Then, click OK.
3. Repair MS Office Application
Sometimes, problems with your MS Office application may cause the Excel has encountered a problem error. In such a case, you need to repair your MS Office application. Here are the steps to do so:
- Launch Control Panel > Uninstall a Program.
- Find your MS Office application and click the Change option.
- A new window will appear. Herein, select the Repair option.
- Now, follow the MS Office installation wizard to finish the repair process.
What to do if the above methods don’t work?
If you have tried the solutions mentioned above and are still not able to resolve the ‘Excel has encountered a problem and need to close’ error, it indicates that the Excel file is corrupt. You can use a professional Excel repair software, such as Stellar Repair for Excel , to repair the corrupt file. The software repairs the file and retrieves all the data, including the tables, charts, formulas, etc. from the damaged workbook. It is compatible with all the MS Excel versions.
To know how Stellar Repair for Excel works, see the following video:
To Wrap Up
The ‘Excel has encountered a problem and needs to close’ error may occur due to different reasons. You can fix this error by following the methods mentioned in this post. If the error has occurred due to corruption in the Excel file, you can use a third-party Excel repair tool, like Stellar Repair for Excel. The software can repair damaged or corrupt Excel file of any size and retrieve all the data.
Also read:
- How to remove Google FRP Lock on Oppo
- How to recover deleted photos from Android Gallery without backup on Y28 5G
- How to recover deleted photos on Poco F5 5G
- How to play HEVC H.265 video on Mix Fold 3?
- How to sign a PDF v1.7 document with electronic signature tool
- How to Repair a Damaged video file of Samsung ?
- How to Honor 90 Get Deleted photos Back with Ease and Safety?
- 2 Ways to Transfer Text Messages from Infinix Smart 8 Pro to iPhone 15/14/13/12/11/X/8/ | Dr.fone
- How to Electronically Sign a .doc file Using DigiSigner
- How to restore wiped call history on Realme C67 5G?
- How to Downgrade iPhone 7 Plus to the Previous iOS Version? | Dr.fone
- How to retrieve erased videos from Oppo Find X7
- How to recover deleted photos from Honor Play 7T.
- How To Restore Missing Pictures Files from Tecno Pop 7 Pro.
- How to retrieve erased messages from 12 Pro 5G
- How to Restore Deleted 11 5G Contacts An Easy Method Explained.
- How to retrieve lost files from Narzo 60x 5G?
- How to restore wiped music on Oppo F23 5G
- How To Restore Missing Photos Files from Infinix Note 30.
- How to Repair Broken video files of Motorola Moto G Stylus (2023) on Windows??
- Unlock Your Realme 12 Pro+ 5G Phone with Ease The 3 Best Lock Screen Removal Tools
- In 2024, How to Use Life360 on Windows PC For Vivo Y27 4G? | Dr.fone
- Best Vivo Y100i Pattern Lock Removal Tools Remove Android Pattern Lock Without Losing Data
- Reliable User Guide to Fix Honor Magic 6 Running Slow and Freezing | Dr.fone
- How To Fix Unresponsive Touch Screen on Vivo V27 Pro | Dr.fone
- Updated In 2024, You May Want to Create Your Video Tutorial and Share Your Knowledge with Others. Fortunately, You Can Easily Create a Professionally Edited Tutorial Video with Filmora. Keep Reading This Article Since We Will Show You How to Do It
- In 2024, 9 Best Phone Monitoring Apps for Oppo A59 5G | Dr.fone
- How to Bypass Activation Lock from Apple iPhone 6s or iPad?
- Updated What Is AI Advertising? | Wondershare Virbo Glossary for 2024
- How to Fix It Nokia G310 Wont Turn On | Dr.fone
- 3 Solutions to Hard Reset Poco M6 5G Phone Using PC | Dr.fone
- A Step-by-Step Guide on Using ADB and Fastboot to Remove FRP Lock from your Tecno Spark 10 4G
- Updated How to Create a Clideo Slideshow Simply for 2024
- New In 2024, Best 15 Anime Shows That Are Great to Binge Watch
- How and Where to Find a Shiny Stone Pokémon For Apple iPhone XR? | Dr.fone
- In 2024, 5 Ways to Transfer Music from OnePlus 11R to Other Android Devices Easily | Dr.fone
- Title: How to Fix Excel 2021 has Encountered a Problem
- Author: Nova
- Created at : 2024-05-19 18:32:11
- Updated at : 2024-05-21 02:34:23
- Link: https://blog-min.techidaily.com/how-to-fix-excel-2021-has-encountered-a-problem-by-stellar-guide/
- License: This work is licensed under CC BY-NC-SA 4.0.