Get 5 Fixes for Excel File Keeps Closing Automatically | Excel File Recovery Tips Behind

If your Microsoft Excel file keeps closing automatically while editing, it probably because Excel has a crash problem. Here, you can get 5 fixes to get rid of the issue, and in the end follow the tip to recover unsaved Excel file after crash. If you cannot open the Excel file after recovery, apply EaseUS Data Recovery Wizard to fix it alright.

Table of Contents

Q: The Excel spreadsheet keeps closing itself while I'm working in it and also when it is open while working in another window. When I re-open it, a message says an error is causing the problem. I click on the Repair Now button this activity does not keep the spreedsheet from auto-closing every few minutes. Why does my Excel file keep closing itself? I have lost several worksheets due to the unexpectedly auto shutdown.

It seems that there is a conflict arising when you open the Excel application on your Windows PC. Usually, the confict may start within the program itself, or with a thrid-party item that is associated with it. What's more, if you check further on other Microsoft Office suite like Word, PowerPoint, if the problem occurs to the brotherhood applications, the problem is hugely pointed to the Microsoft Office installation and Windows operating system.

related articles

How Does An Excel File Get Corrupted?

Cannot open an Excel workbook due to file corruption? How does an Excel file get corrupted? Can you recover a corrupted Excel file in Windows 10.

mircrosoft excel

If your Microsoft Excel file keeps closing automatically due to the manner of 'copy and past', 'save (as) a file', or just start typing, it probably because Excel has a crash problem. Here, you can get 5 fixes to get rid of the issue.

Workable Solutions Step-by-step Troubleshooting
Fix 1. Check Compatibility Issue To resolve the incompatibility issue...Full steps
Fix 2. Repair MS Office Open Programs and Features in Control Panel...Full steps
Fix 3. Disable DOM Add-ins In Excel, go to File > Options > Add-ins...Full steps
Fix 4. Disable Conditional Formatting Under Home, click Conditional Formatting...Full steps
Fix 5. Launch Excel in Safe Mode Press Windows + R keys to bring up Run...Full steps

FIX 1. Check Compatility Issue of MS Office and Windows 10

First and foremost, you should recall two things that may help you figure out when and what causes the crashing problem. [1] What is the version of the Excel application currently installed on your PC? [2] Did you update your Windows 10 system in recent days? Is the date happening to be the day the Excel file starts closing automatically? If you've done either of the things here, you should ask yourself: Is this version of Excel compatible with Windows 10? For an older version of Excel, like before 2013, even you don't subject to the stability issue right now, we still recommend you turn to the new version to be able to run in Windows 10.

To resolve the incompatility issue of Excel and Windows 10, except using the newer version of Excel, you can also try to run the present Excel in Windows Compatibility Mode taught by Microsoft Support.

Make older apps or programs compatible wiht Windows 10

FIX 2. Repair MS Office

When your Excel starting issue like crash, freezing, not responding and like now closing itself automatically, you should be very careful with creating new file because the file will be completely in danger of losing content. We advise you have a check on Word. See if the same problem happens to Word, or other Office Suite like PowerPoint. If yes, then it's sure about the Microsoft Office issue and it needs repair.

  • 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

repair ms office to fix excel file closing automatically

  • Select Quick Repair and click the Repair button

repair ms office to fix excel file closing automatically

Fix 3. Disable COM Add-ins

The COM add-ins are bad while editing on a large Excel file. It consumes memory a lot, and easily causes genere issues in the Excel file to freeze and crashing. So it's highly suggested to disable add-ins in Excel.

  • In Excel, go to File> Options> Add-ins
  • Choose COM Add-ins from the drop-down and click Go
  • Uncheck all the checkboxes and click OK

disable add-ins to fix excel file closing automatically

FIX 4. Disable Conditional Formatitng Rules

Did you use the Conditional Formatting Rules on some specific spreadsheets? The Conditional Formatting Rules is based on choosing different color to highlight or differentiate information storaged in a spreadsheet. If you're facing the Excel file closing automatically a few times only in a particular Excel spreadsheet, you can consider not using this feature at the moment, to check if the Excel file can work normally again.

  • Under Home, click Conditional Formatting
  • Choose Clear Rules
  • Select Clear Rules from Entire Sheet
  • Close and restart the Excel file again

disable conditional formatting rules to fix excel file closing automatically

FIX 5. Launch Excel in Safe Mode

If the previous four solutions are not in line with your case, and you're still in trouble, try to launch Excel in Safe Mode this time. If it's not the problem within the program, it might be some unknown startup processes are interrupting its performace. 

  • Press Windows + R keys to bring up Run
  • Type excel.exe /safe and hit Enter

run excel in safe mode to fix excel file closing automatically

How to Recove Unsaved Excel Files After Automatically Closing

Data loss is the most direct consequence brought by the problem - Microsoft Excel file closing automatically. The good side is that Microsoft Office has the ability to save your draft while editing in a recoverable folder. The auto save feature is usually turn on by default, unless you have disabled it by youseflt, it's likely that you can recover an unsaved Excel file from the autorecover folder.

To recover unsaved Excel files from AutoRecover:

  • Open a new Excel file in Windows
  • Click File > Open > Recent Workbooks
  • Then check the recently used Excel document and find the unsaved file due to a sudden Excel close

recover unsaved excel file step 1

  • Click Recover Unsaved Workbooks and wait to let the program recover your closed Excel file

recover unsaved excel file step 2

  • On the new pop up window telling you that there is a recovered file that is temporarily stored on your computer, clic Save AS to store the Excel as a new file to a safe location on your PC

recover unsaved excel file step 3

How to Recover Corrupted Excel File That Won't Open After Recovery

After finding the unsaved Excel file from the auto saved location, you may still encounter an issue that it cannot open normally. What's more, there is no clear path guiding you to the auto recover location as well, though the auto save feautre is indeed enabled. If you're facing the problem likewise, you can proceed with the best file recovery software - EaseUS Data Recovery Wizard to continue repairing the file and bringing back its content.

Step 1. Select a location to start finding corrupted Excel files

Launch EaseUS Data Recovery Wizard, and then scan the corrupted or damaged Excel files.

repair Excel file - 1

Step 2.  Scan for the corrupted Excel document

Find the damaged files through the filter, file path, search, etc.

repair damaged Excel files

Step 3.  Repair and save the Excel file to a secure location

Double-click the corrupt excel file, and this program will automatically repair corrupted and damaged Excel files. Click "Recover" to save the repaired Excel files to a safe location.

Save repaired Excel files

Was This Page Helpful?

author icon

Updated by Jean

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!

Read full bio

Product Reviews

TrustScore 4.7 | 323 reviews
  • 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