Lets Try That Again Opening Word

When working with Excel spreadsheets, almost people are either brusk on time or take a borderline to meet.

And it could be a nightmare if, at that point in time, Microsoft Excel decides not to open up (arghhhhh!).

Unfortunately, this unexpected behavior is quite common where Excel refuses to open one of your of import Excel files, or fails to open the Excel application birthday.

So, if you are suffering from the 'Microsoft-Excel-won't-open up' syndrome, this commodity is just what you lot demand.

In this tutorial, I will cover the reasons why Excel refuses to open and the possible solutions that can help you lot in this state of affairs.

So let's get started!

• Possible Reasons Why Microsoft Excel Won't Open up
• How to Prepare Excel Files Not Opening
  • Uncheck the Ignore DDE box
  • Turn OFF Add-ins
  • Repair Microsoft Office
  • Reset Excel File Associations
  • Disable Hardware Graphics Dispatch
  • When Everything Fails

Possible Reasons Why Microsoft Excel Won't Open

Since Excel is a tool that has to piece of work seamlessly with other applications and operating systems, there are many things that can go wrong with it.

And of class, in that location is ever a possibility that the Excel awarding in itself is the problem.

Below are some possible reasons due to which Microsoft Excel won't open on your system:

1. There is a problematic add-in that is not assuasive you to open Excel files. If this is the case, most likely y'all will exist able to open the Excel applications, only not a specific Excel file (or a new Excel file)
2. There is a possibility that your Excel awarding is corrupt and needs to exist repaired before you can start opening Excel files again
3. Your Excel awarding is not able to communicate with other applications and the operating system. This has a uncomplicated fix where you lot tin simply enable the setting and your files would start working once again (covered later in this tutorial)
4. The file Association is broken which means that when you try and open up an Excel file, it doesn't know what software to use to open the file. This again has an piece of cake fix, where you can only reset the file associations. A lot of people who take upgraded their Excel or operating arrangement often face this issue
5. The file that you want to open is corrupt. This oft happens when someone else shares the file with you or when you copy the file to a network drive or an external drive and transfer it to your system. There'southward non much you tin can practise in this case, except to make sure that yous create backups of your files in the future

How to Fix Excel Files Not Opening

Now, let'southward accept a look at some of the methods that you can use to gear up the issue of Excel files not opening.

I'thou list these fixes in an gild in which these are almost likely to work.

Uncheck the Ignore DDE box

The most common and easiest set 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, but in example it gets enabled by whatsoever adventure, then it could lead to your Excel files not opening on your organisation.

When this happens, you will be able to open your Excel application from the showtime menu, but you won't be able to open up individual Excel files.

Below are the steps to set this DDE issue:

1. Open up the Excel file from the Start menu
2. Click the File Tab
3. Click on Options
4. In the Excel Options dialog box that opens upwardly, click on the 'Advanced' option on the left pane
5. Scroll downward to the Full general section
6. Make sure the 'Ignore other applications that employ Dynamic Data Exchange (DDE)' setting is disabled.
7. Close the Excel Options dialog box

If this setting was enabled earlier and y'all accept disabled information technology using the to a higher place steps, this was most likely the issue and information technology should get sorted now.

In case this method doesn't work, go on reading!

Turn OFF Add-ins

A lot of people use tertiary-party add-ins in Excel that allow them to raise the functionality and be able to use many features that are not 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 allowed us to create cute charts that were not possible with Excel itself.

And sometimes these add-ins stop upward existence the problem where you not able to open your Excel files.

Information technology has an easy fix – disabling the add-in.

Below the steps that yous can apply to disable an add-in in Excel:

1. Open the Excel file from the Start menu
2. Click the File Tab
3. Click on Options
4. In the Excel Options dialog box, click on the Add together-ins pick in the left-pane
5. At the bottom of the dialog box, click on the Manage drop-downward
6. Click on COM Add together-ins
7. Click on Become
8. In the COM Add-ins dialog box that opens, disable all the add together-ins
9. Click Ok

Now try and open an Excel file that wasn't opening earlier. If the item was the consequence, the file should open at present.

Many a time, it's a one-off issue and the add together-in will work perfectly even if you enable it now. In example you enable the add together-in and y'all even so face the same problem, you tin can exist sure that the add-in is corrupt I need to exist permanently disabled.

Repair Microsoft Office

Some other possible reason that causes Excel files to not open could exist that your Microsoft Office application is decadent and need to be repaired or reinstalled.

But since reinstalling is a little more work, let's try the repair selection first.

Follow the steps below to repair the Microsoft Office application on your system:

1. Hold the Windows key and press the R key. This will open the 'Run' dialog box
2. Enter the following text in the run box – 'appwiz.cpl'. This will open up the programs and features dialog box
3. Locate Microsoft Office in the listing
4. Correct-click on the Microsoft Office option and click on Change (in case yous see the repair option correct hither, click on it)
5. In the dialog box that shows upwardly, click on the Quick Repair option
6. Click on the Repair push

Follow through with the steps that show up and within a few minutes, it volition repair your Microsoft Office application.

If a corrupt Microsoft Part awarding was the event, it should be fixed with the above steps.

Merely in instance you're yet not able to open up Excel files, permit's endeavor more fixes.

Reset Excel File Associations

File Association is what makes sure that when you open an Excel file, it uses the Excel application to open up that file.

And sometimes, these file associations get wrong and when y'all click on an Excel file, information technology would not know that it needs to utilize the Excel application to open up it.

The fix – resetting file associations

Below are the steps on how you can do this:

1. Open the Control Panel
2. Click on Programs
3. Click on Default Programs
4. Click on 'Prepare your default programs'
5. In the Default apps windows that opens, gyre down to the 'Reset to the Microsoft recommended defaults' and click on the Reset button.

If a mismatched file association was the result that was not letting your Excel files open, this would fix it.

Annotation that since we accept reset the default for all the applications on your system, in example you had manually made any changes and specified whatsoever specific file extension to exist opened with a specific application, that would likewise be set to the default.

If you don't want to reset the default for all the applications and only for the Excel files, click on the 'choose default applications by file type' option.

In the screen that shows upward, locate the Excel files extensions (.xls, .xlsx, .xlsb, .csv, etc.) and set XLS the default application for these.

Disable Hardware Graphics Acceleration

Hardware graphic acceleration is something that helps your organization perform better, especially when using Microsoft Office applications such every bit MS Excel or MS Discussion.

Just many times, this may also lead to your Excel files non opening or your system or files crashing.

So, if everything else fails, it's worth trying this method.

Hardware graphic acceleration is enabled past default and disabling information technology can solve the upshot.

Here is how you can do it:

1. Open the Excel applications
2. Click on the File tab
3. Click on Options
4. In the Excel Options dialog box that opens upwards, click on the Avant-garde tab in the left pane
5. Ringlet down to the 'Display' settings
6. Check the – 'Display hardware graphic dispatch' option
7. Click OK

If hardware graphic dispatch was the issue, your Excel files should outset opening now.

When Everything Fails – Reach out to the Microsoft Support

And finally, there is but so much troubleshooting you can do.

If nothing else has worked for yous so far, it'south all-time to reach out to Microsoft support and encounter if those guys tin assistance you.

Many times, these issues could also ascend from some recent update that Microsoft released which may have inadvertently acquired this outcome.

You can utilise the below link to contact Microsoft support:

https://back up.microsoft.com/contactus/

Another thing you can attempt is posting your query on many active Microsoft forums, and the awesome folks of the Net may come to your rescue.

I know that this is non an platonic solution, but information technology tin help you lot get feedback and solutions from experts, which is helpful in almost all cases.

So these are the methods that you can use to troubleshoot when your Microsoft files won't open.

In most cases, it should be sorted by unproblematic setting changes such as disabling third-party add-ins or resetting file associations, and in some rare cases if you're not able to place the consequence the best thing is to reach out to Microsoft back up.

I hope you institute this tutorial useful.

Other Excel tutorials yous may also like:

• How to Automatically Open Specific Excel File on Startup
• Excel Formulas Non Working: Possible Reasons and How to Ready IT!
• x Tricks to Prepare Slow Excel Spreadsheets (Speed-up Excel)
• #REF! Error in Excel – How to Set up the Reference Error!
• How to Recover Unsaved Excel Files [All Options + Precautions]
• Arrow Keys not Working in Excel | Moving Pages Instead of Cells

wasingerclany1963.blogspot.com

Source: https://trumpexcel.com/microsoft-excel-wont-open/

Share this post