8 Fixes To Resolve Excel File Closes Immediately After Opening Issue

Does your Excel file closes immediately after opening due to which you are unable to perform any action on your workbook? Do you know why Excel closes without warning?

If not then I have outlined some best fixes to resolve Excel 2016 opens and closes immediately issue. So just go through it….!

Best Software To Fix Excel File Closes Immediately After Opening:

Due to the occurrence of this Excel automatically closes when opening file issue, you may face problems like Excel file corruption or damage.

Such types of Excel files can’t get accessed or opened using the app and when you try to access it your Excel keeps crashing.

In such a situation, you need to immediately recover your Excel file either from your kept backup or by making use of the Excel Repair software.

You can download this software for free. After repairing the excel file, try to save it in your desired location.

* Free version of the product only previews recoverable data.

What Error Message Occurs When Excel File Closes Immediately After Opening?

If your Excel closes without warning then it’s a sign that the application is crashing, freezing, or stopped working.

In such a situation, you will get the following error messages:

Excel has stopped working

Excel Cannot Open the File

How To Fix Excel Not Responding Error

Why Does Excel File Closes Immediately After Opening?

If your Excel opens and closes immediately then the following are the responsible causes behind this:

  • Outdated MS Excel application
  • Network connection Problem
  • Incompatible Add-Ins
  • Excessive Cell formatting and styling
  • Improper installation of MS Office application.
  • Confliction with some other application or antivirus tool
  • Partially corrupted or damaged Excel file
  • Excel file created by 3rd party software

How To Fix Excel File Closes Immediately After Opening Issue?

Here are some best fixes to resolve Excel file closes immediately after opening issue.

1: Copy File To Local Drive
2: Ensure Sufficient Memory
3: Check Whether Excel Is Open By Another Process
4: Repair Or Reinstall MS Office
5: Restart Excel In Safe Mode
6: Check And Remove Faulty Add-ins
7: Check Software Installation
8: Remove Protected-View Of Excel
9: Prevent Automatic Running Macros When You Start Excel

1: Copy File To Local Drive

If your Excel crashes when opening file from network then immediately copy or move your file to a local drive.

As it is the best way to find whether there is a problem with the file or in the network.

2: Ensure Sufficient Memory

Excel file keeps growing larger in size with the usage mainly when you start adding a number of shapes and formatting. In such a situation chances of large Excel file keeps crashing becomes too high.

So make sure that you have enough RAM space for the execution of the Excel application.

If you are working with some oversized Excel files and complex data in that case it’s better to install 64-bit versions MS Office application.

This gives you the advantage of larger processing dimensions which ultimately help you to get rid of Excel shut down unexpectedly problem.

3: Check Whether Excel Is Open By Another Process

Excel auto close problem also arises when Excel is already in use by another process and you are trying to re-open it again.

  • At first, open your Task Manager to end up all the running processes or apps.
  • For this, you need to make a right-click on your screen’s taskbar and then choose the “start task Manager” option.
  • Now from the opened Windows task manager choose the running application and hit the End task button.

close excel file from task manager 2

  • You can also switch to other tabs like processes or services in this opened task manager for ending up the processes or disabling all the unwanted services.

close excel file from task manager

After ending up the application or processes execution check whether you are still facing the Excel shut down unexpectedly issue.

4: Repair Or Reinstall MS Office

By repairing MS Office applications issues like Excel open and closes immediately can easily be fixed.

In such a situation, perform the following options.

  • Shut down all the MS Office apps if it is opened.
  •  Now got the Control Panel >programs> Uninstall a program option.

control panel

  • Select the MS Office program and then hit the Change option.

ms office repair from control panel

  • Hit any option out of ‘Quick repair’ or ‘online repair’. After that tap the ‘Repair‘ button.

ms office repair from control panel 1

  • Tap to the ‘Continue‘ option for MS Office installation repair.

Repair the MS Office suite

5: Restart Excel In Safe Mode

By running your Excel application in the safe mode, you can prevent your excel program to get executed without loading Excel add-ins. In this COM add-ins are get excluded.

Method 1# 

To run the excel application in the safe mode, follow down these steps:

  • Make a shortcut of MS Excel application.
  • At the time of launching the Excel program, don’t forget to press the Ctrl key.
  • When the confirmation dialog box gets open tap the ‘Yes‘ button.

Method 2#  

  • Hit Windows + R key from your keyboard.
  • After that in the opening run window type, Excel.exe/safe, and press the enter button.

open excel in safe mode

  • Now you will see that your Excel file gets opened in the safe mode.

open excel in safe mode 1

6: Check And Remove Faulty Add-ins

Excel closes automatically after opening file when some faulty add-ins start causing the issue. Such Excel add-ins conflict and interferes with your Excel program. So you need to immediately fetch and remove the faulty add-in. here are the steps that you need to follow:

  • Restart your Excel application normally.
  • Hit the File> Options> Add-ins.

Inspect issues with Add-ins 1

  • Now in the Excel option window, select the COM Add-ins from your drop-down menu and hit the Go button.

Inspect issues with Add-ins 2

  • Unselect all the checkboxes and hit the OK button.

Add-Ins-in-Excel

  • Restart your Excel application and check whether the issue has been resolved or not.

One by one enable the add-ins if Excel opens and closes immediately problem keeps continued.

7: Check Software Installation

If you have recently installed any software then check the following:

  • Firstly open the “Control Panel“.
  • Select “Programs” > “Uninstall a Program“.

control panel

 

  • Sort the list by “Installed On“.
  • If another new program gets installed that may cause the issue, you may want to experiment with uninstalling it to clear this problem.

uninstall program from control panel

8: Remove Protected-View Of Excel

Excel file that gets opened from a potentially unsafe location like the internet, email attachments, downloaded from any third party source, etc. are opened in protected view.

This feature of Excel Protected-View restricts the user to make any modification in their opened Excel spreadsheet.

So, you can turn off the Protected-View security warning messages in Excel to resolve Excel 2016 open and close immediately like problems.

here are the steps to followed to remove Excel file from Protected-View :

  • Open MS Excel
  • Go to the File ->Options
  • Select the Trust Centre ->Trust Centre Settings

  • Click on the Protected View
  • Uncheck all the options

Also, change the below-given settings

  • Under the Trust Centre settings,
  • Click on the ‘File Block Settings’

  • Uncheck all the options and click the OK button.

9: Prevent Automatic Running Macros When You Start Excel

There are such automatic macros in Excel as Auto_Open which gets recorded in your workbook. So, when you start your Excel application it will automatically run itself.

For stopping the automatic running of macros you need to just hold on to the SHIFT option at the time of starting your Excel application.

Conclusion

I have provided several promising ways to fix Excel file closes immediately after opening issue. All the above-listed fixes are easy to apply and implement.

If none of the listed manual methods work to fix Excel automatically closes when opening file problem then go the reliable solution like Excel repair tool.

If you have any questions related to the article, then freely ask it on our Repair MS Excel Facebook and Twitter page.



Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to understand language is very impressive. When not writing, she loves unplanned travels.