Excel Workbook Opens Up Again After Closing
When working with Excel spreadsheets, virtually people are either brusk on fourth dimension or have a deadline to encounter.
And it could be a nightmare if, at that signal in time, Microsoft Excel decides not to open (arghhhhh!).
Unfortunately, this unexpected behavior is quite mutual where Excel refuses to open ane of your important Excel files, or fails to open up the Excel application birthday.
And then, if you lot are suffering from the 'Microsoft-Excel-won't-open' syndrome, this article is just what you demand.
In this tutorial, I will cover the reasons why Excel refuses to open and the possible solutions that tin help y'all in this situation.
So let's get started!
Possible Reasons Why Microsoft Excel Won't Open up
Since Excel is a tool that has to work seamlessly with other applications and operating systems, there are many things that tin go wrong with it.
And of course, there is e'er a possibility that the Excel application in itself is the problem.
Beneath are some possible reasons due to which Microsoft Excel won't open on your organisation:
- There is a problematic add-in that is not allowing you to open up Excel files. If this is the case, about likely y'all will be able to open the Excel applications, but non a specific Excel file (or a new Excel file)
- There is a possibility that your Excel application is corrupt and needs to be repaired earlier you can start opening Excel files again
- Your Excel awarding is not able to communicate with other applications and the operating system. This has a simple fix where you lot tin can simply enable the setting and your files would start working again (covered later in this tutorial)
- The file Association is cleaved which ways that when yous try and open an Excel file, it doesn't know what software to use to open up the file. This again has an easy fix, where you can merely reset the file associations. A lot of people who have upgraded their Excel or operating system oft face this issue
- The file that you want to open is corrupt. This often happens when someone else shares the file with y'all or when you copy the file to a network drive or an external bulldoze and transfer it to your system. In that location's not much you tin exercise in this case, except to brand sure that you create backups of your files in the future
How to Prepare Excel Files Not Opening
Now, let'south have a look at some of the methods that you lot can use to fix the result of Excel files not opening.
I'm listing these fixes in an order in which these are most probable to work.
Uncheck the Ignore DDE box
The most common and easiest gear up is to make sure that the correct setting is enabled for the Dynamic Data Exchange (DDE).
DDE is how Excel interacts with other applications.
By default, the DDE setting is disabled, just in case it gets enabled past any chance, then it could pb to your Excel files not opening on your organisation.
When this happens, yous will exist able to open your Excel application from the start menu, merely y'all won't be able to open individual Excel files.
Below are the steps to prepare this DDE issue:
- Open the Excel file from the Start card
- Click the File Tab
- Click on Options
- In the Excel Options dialog box that opens upwards, click on the 'Advanced' option on the left pane
- Gyre down to the General department
- Brand sure the 'Ignore other applications that utilise Dynamic Information Substitution (DDE)' setting is disabled.
- Shut the Excel Options dialog box
If this setting was enabled earlier and y'all accept disabled it using the higher up steps, this was virtually likely the consequence and information technology should get sorted now.
In example this method doesn't work, proceed reading!
Plough OFF Add-ins
A lot of people use third-party add-ins in Excel that allow them to enhance the functionality and exist able to apply many features that are non there in Excel by default.
One of the add-ins that I used to use in my full-time day job days was 'ThinkCell', which immune the states to create beautiful charts that were not possible with Excel itself.
And sometimes these add-ins finish up existence the trouble where you not able to open up your Excel files.
It has an easy fix – disabling the add-in.
Below the steps that y'all can use to disable an add-in in Excel:
- Open up the Excel file from the Start menu
- Click the File Tab
- Click on Options
- In the Excel Options dialog box, click on the Add-ins selection in the left-pane
- At the lesser of the dialog box, click on the Manage drib-downward
- Click on COM Add-ins
- Click on Go
- In the COM Add together-ins dialog box that opens, disable all the add-ins
- Click Ok
Now effort and open an Excel file that wasn't opening earlier. If the item was the issue, the file should open now.
Many a fourth dimension, it's a one-off issue and the add-in will work perfectly even if you enable it now. In case you enable the add-in and y'all however face the same trouble, yous can be sure that the add-in is decadent I need to be permanently disabled.
Repair Microsoft Office
Another possible reason that causes Excel files to not open could be that your Microsoft Office application is corrupt and demand to be repaired or reinstalled.
Simply since reinstalling is a lilliputian more work, let's endeavor the repair pick first.
Follow the steps below to repair the Microsoft Function application on your organization:
- Hold the Windows key and press the R cardinal. This will open the 'Run' dialog box
- Enter the following text in the run box – 'appwiz.cpl'. This will open the programs and features dialog box
- Locate Microsoft Office in the listing
- Correct-click on the Microsoft Role selection and click on Modify (in case y'all run across the repair option correct hither, click on it)
- In the dialog box that shows up, click on the Quick Repair selection
- Click on the Repair button
Follow through with the steps that bear witness upwards and within a few minutes, it volition repair your Microsoft Role awarding.
If a corrupt Microsoft Office awarding was the issue, it should be fixed with the above steps.
But in example you're still non able to open Excel files, let'south try more fixes.
Reset Excel File Associations
File Association is what makes certain that when you open an Excel file, it uses the Excel application to open that file.
And sometimes, these file associations become wrong and when you click on an Excel file, it would not know that it needs to utilise the Excel application to open information technology.
The fix – resetting file associations
Below are the steps on how you can do this:
- Open the Control Console
- Click on Programs
- Click on Default Programs
- Click on 'Set up your default programs'
- In the Default apps windows that opens, scroll down to the 'Reset to the Microsoft recommended defaults' and click on the Reset button.
If a mismatched file association was the issue that was not letting your Excel files open up, this would fix it.
Annotation that since we have reset the default for all the applications on your system, in case you had manually fabricated any changes and specified any specific file extension to exist opened with a specific awarding, that would too be prepare to the default.
If you lot don't want to reset the default for all the applications and just for the Excel files, click on the 'cull default applications by file type' option.
In the screen that shows up, locate the Excel files extensions (.xls, .xlsx, .xlsb, .csv, etc.) and gear up XLS the default application for these.
Disable Hardware Graphics Dispatch
Hardware graphic acceleration is something that helps your organization perform ameliorate, particularly when using Microsoft Office applications such equally MS Excel or MS Give-and-take.
Just many times, this may also lead to your Excel files not opening or your system or files crashing.
So, if everything else fails, it's worth trying this method.
Hardware graphic acceleration is enabled by default and disabling it tin solve the issue.
Here is how you tin can do it:
- Open the Excel applications
- Click on the File tab
- Click on Options
- In the Excel Options dialog box that opens up, click on the Avant-garde tab in the left pane
- Scroll downwardly to the 'Brandish' settings
- Check the – 'Display hardware graphic acceleration' pick
- Click OK
If hardware graphic acceleration was the event, your Excel files should start opening now.
When Everything Fails – Reach out to the Microsoft Support
And finally, there is only and then much troubleshooting y'all can do.
If zero else has worked for you lot so far, it'due south best to achieve out to Microsoft support and come across if those guys can aid you.
Many times, these issues could also arise from some recent update that Microsoft released which may accept inadvertently acquired this result.
You can use the below link to contact Microsoft back up:
https://support.microsoft.com/contactus/
Another affair you can effort is posting your query on many active Microsoft forums, and the awesome folks of the Internet may come to your rescue.
I know that this is not an ideal solution, but it tin can assistance y'all get feedback and solutions from experts, which is helpful in nigh all cases.
So these are the methods that you lot tin can utilise to troubleshoot when your Microsoft files won't open.
In nigh cases, it should be sorted by uncomplicated setting changes such as disabling third-party add-ins or resetting file associations, and in some rare cases if y'all're not able to identify the issue the best thing is to reach out to Microsoft support.
I hope y'all establish this tutorial useful.
Other Excel tutorials you may also like:
- How to Automatically Open Specific Excel File on Startup
- Excel Formulas Not Working: Possible Reasons and How to FIX IT!
- 10 Tricks to Set Slow Excel Spreadsheets (Speed-up Excel)
- #REF! Fault in Excel – How to Fix the Reference Error!
- How to Recover Unsaved Excel Files [All Options + Precautions]
- Arrow Keys not Working in Excel | Moving Pages Instead of Cells
Source: https://trumpexcel.com/microsoft-excel-wont-open/