Excel won’t open files, shows a white screen instead? You can fix that

Microsoft Excel users have reported issues with the program with regards to opening files. If you’ve had a similar experience, you’ve probably noticed that when you try to double-click on an Excel file or an icon for a workbook, the program starts up but you get a blank white screen instead of the intended file.

Some users have circumvented this issue by using File > Open > Workbook, but its much easier to just double click, right?

However, the issue, as described by Microsoft Support, arises from the fact that Excel got a security upgrade such that there are changes in the behavior of certain types of files in the way they open in Excel.

This change, as explained, came with three security updates: KB3115322, KB3115262, and KB3170008.

Unlike the former times when you would try to open HTML or XLA files with an Excel .xls extension, the program would caution over the disconnect between the file and contents but open without Protected View security.

After these updates, the program will not open workbooks but will show a blank screen instead, because the files you may be trying to open are incompatible with the program’s Protected View feature. It doesn’t even warn you that it did not open the file.

We share some quick fix solutions you can use to resolve the issue of Excel not opening your files so you can simply double click and access your workbooks.

Excel won’t open files: Here’s how to quickly fix the problem

  1. Uncheck the Ignore DDE box
  2. Reset Excel file associations
  3. Repair Microsoft Office
  4. Turn off add-ins
  5. Disable Hardware Graphics Acceleration
  6. Contact Microsoft Support

Solution 1: Uncheck the Ignore DDE box

One of the reasons your Excel program is not opening files may be caused by the Ignore other applications that use Dynamic Data Exchange (DDE) option selected.

The function of the DDE is to send a message to the program once you double-click, which then instructs it to open the file or workbook you have double clicked to open.

Here are the steps to go about this solution:

  • Open Excel program
  • If it opens a new workbook, go to File
  • Click on Options
  • Click on Advanced
  • Locate General tab
  • Uncheck the Ignore other applications that use Dynamic Data Exchange (DDE) box
  • Click Ok

Note: if you select Ignore, Excel ignores all DDE instructions sent from other programs to itself, thus it will not open the workbook you have double-clicked.

Download this tool we highly recommend

You can fix this issue and open hundreds of other file formats with a single application. FileViewer Plus is a universal file viewer for Windows that can open and display over 300 different file types, with support for Word, PowerPoint, Excel, Visio, and Project files. You can download it for free from the official website or buy it at an affordable price.

  • Download now FileViewer Plus

Solution 2: Reset Excel file associations

You’ll need to reset the Excel file associations to default settings, and here are the steps to follow:

  1. Right-click Start button
  2. Select Control Panel
  3. Click Programs then click Default Programs
  4. Under Default Programs, click the Set your default programs A search process will begin to find your default programs
  1. From the list of default programs, choose Excel
  2. Click Choose default for this program
  • The Set Program Associations screen will open up
  • Click Select All
  • Click Save which sets off the saving process
  • Click Ok

Once you do the above, reboot your computer.

Solution 4: Turn off add-ins

There are two types of add-ins that can cause Excel program not to open files. These are:

  • Excel add-in
  • COM add-in

These add-ins need to be turned off one after the other if you have to test, disable and isolate the issue, and here’s how to go about it:

  • Open Excel program
  • If it opens a new workbook, go to File
  • Click on Options
  • Click Add-Ins
  • Locate Manage at the bottom of the open screen
  • On the drop-down, select COM Add-ins
  • Click Go
  • From the open box, clear one of the add-ins on the list
  • Click Ok

Once all these steps are followed, restart Excel program by double-clicking on a file or icon of the workbook you want to open.

Note: in case the problem recurs, repeat the first seven steps, then choose a different add-in to clear, and try this as you go along. If it opens, then you’ll know the add-in you selected last is the one causing the issue, in which case you can find an update or newer version of the add-in from the manufacturer’s website, or, if unavailable, you can leave it off.

Solution 5: Disable Hardware Graphics Acceleration

Follow these steps to disable hardware graphics acceleration:

  • Open Excel program
  • Go to File
  • Click Options
  • Click Advanced
  • Find Display tab
  • Locate the Disable hardware graphics acceleration box and select it
  • Click Ok

Solution 6: Contact Microsoft Support

If none of the above solutions worked, then contact Microsoft Support for further options.

Did any of these solutions work for you? Share with us in the comments section.

Leave a comment

Your email address will not be published. Required fields are marked *