excel-opening-blank-files

Are you the one facing the issue Excel opens but the spreadsheet won’t open or a blank screen appears only. The Excel file appears blank with no cells, no column or rows names, and no gridlines.

This is a very irritating issue faced by the Excel users while trying to open files. When the users double-click on an Excel file or on the workbook icon, the program starts but a blank screen appears with a white screen or in some cases grey screen instead of the projected file.

Well, even some users are getting the issue by using File > Open > Workbook.

Not happy with your MS Excel performance?
Don't Miss The BEST TOOL To FIX .xls/.xlsx Errors & Issues

It doesn’t’ matter whether the screen appears grey or white this is very annoying. And Microsoft Support has described that issue arises after the installing the security upgrade.

The security updates KB3115322, KB3115262 & KB3170008 in Excel made changes in certain types of the files and the way they open. When the users try to open HTML or XLA files with an Excel .xls extension, than the program would caution over detachment between files and contents however opens without Protected View security.  

And after installing the security updates, the program won’t open workbooks but show blank screen, because the files become incompatible with the program’s Protected View feature. There is no any warning message appears related to the issue.

Here in this article I am going to describe the complete information to troubleshoot Excel won’t open only blank screen appears.

Some Examples Related To Excel Won’t Open Blank Screen Appears:

Excel Opens Blank Grey Screen: While working on Microsoft Excel many users are facing the grey screen issue. This error is faced by the users who updated their system from 2007 or 2010 to Excel 2016.  However this is not limited to Excel 2016, Excel 2013 users are also facing the same issue.

Excel Won’t Open White Screen: This is another issue related to the Excel opens blank screen issue. While trying to open Excel file many users are getting the White screen. Well this issue is particularly faced by the Excel 2016 users on Windows 10 operating system.

These are the two cases faced by the users while trying to open Excel workbook. So here check out the working solutions to resolve Excel not opening files issues and simply access your workbook.

 

How to Fix Excel Won’t Open Blank Screen Appears:

 

Well, there is no any exact fix for the problem, so here try the different given fixes and check which one works for you. The below-given solutions work well in both the cases grey screen and white screen issue, so try them in your case.

 

Solution 1: Uncheck the Ignore DDE Box

 

One obvious reason or getting Excel program not opening files is choosing the Ignore DDE box (Ignore other applications that use Dynamic Data Exchange).

The DDE function is to send a message to the program when the user doubles click, and then instructs it to open file or workbook that have been double clicked to open.

Follow the steps to do so:

  • Open Excel program
  • If a new workbook open go to File > Options > Advanced> locate General tab
  • Now, uncheck Ignore other applications that use Dynamic Data Exchange (DDE) box
  • Lastly, click Ok

Please Note: Selecting the Ignore DDE box, will not open the workbook when double-clicked, as Excel ignores the entire instructions sent for other programs to itself.

However, this is a working solution that helped many users to open the Excel by troubleshooting the Excel not opening White or grey screen displays issue.

Read Also: Repair Excel Error “Opening Blank Page Issue When You Double-Click A File Icon Or File Name”

Solution 2: Check Hide/unhide

 

Well, you can also try this to fix the Excel opening blank screen workbook issue. Users can hide Excel documents by selecting the Hide option. And as a result, a blank screen appears instead of the actual spreadsheet document.

So here it is recommended to check if the hide option is enabled or not and “unhide” data.

 

Solution 3: Reset Excel File Associations

 

Try resetting the Excel file associations to its default settings to resolve Excel won’t open files issue.

Follow the given instruction to do so:

  • Go to Start > choose Control Panel > Programs > click Default Programs
  • Then under Default Programs > click Set your default programs ( Search process will begin to find your default programs)

  • And from the default programs list > select Excel
  • Click Choose default for this program > a Set Program Associations screen appears.

  • Click Select All > Save > OK

Hope doing this will help you to fix Excel file not opening blank grey screen or white screen appears and access your Excel file easily.

You May Also Read:

Solution 4: Repair Microsoft Office

 

Well, in many cases the Microsoft office issue also causes various problems, so here it is recommended if yet the issue is not resolved then try repairing Microsoft Office programs.

Follow the steps to do so:

  • Go to Start button > Control Panel > Programs
  • Now click Uninstall Programs > Microsoft Office
  • And click Change

  • Click Online Repair > click Repair

As the whole repairing process is finished restart your PC and check if the issue is resolved.

 

Solution 5: Turn Off Add-ins

 

Excel add-ins in many cases interfere with the documents loading so here check for the add-ins.

There are two types of add-ins that can cause issue in Excel commonly Excel program not to open files.

  • Excel add-in
  • COM add-in

So turn off the add-ins, and check if this helps you.

  • Open Excel > If a new workbook opens > go to File
  • Click Options > Add-Ins

  • And find Manage option bottom of the open screen

  • On the drop-down > COM Add-ins > click Go

  • Then from the box > clear one of the add-ins on the list
  • Click Ok

After finishing the whole steps double click on the file to restart your Excel program

Please Note: If in case still the problem is not resolved then follow the given steps and select the different add-in and remove it. And try opening the Excel workbook again.

 

Solution 6: Disable Hardware Graphics Acceleration

 

Try disabling the hardware graphics acceleration option, this helped many users to fix Excel no opening issue.

Follow the steps to do so:

  • Open Excel program > File > Options
  • Click Advanced > find Display tab

  • Now locate the Disable hardware graphics acceleration box > select it

  • Click Ok

Check if the Excel won’t open file white screen appears is resolved or not.

 

Solution 7: Contact Microsoft Support

 

If none of the above given solutions helped you to fix the issue then the best is to contact Microsoft Support for further options.

 

Automatic Solution: MS Excel Repair Tool

 

Make use of the professional recommended MS Excel Repair Tool to repair corrupt, damaged as well as errors in Excel file. This tool allows to easily restore all corrupt excel file including the charts, worksheet properties cell comments, and other important data. With the help of this, you can fix all sort of issues, corruption, errors in Excel workbooks. This is a unique tool to repair multiple excel files at one repair cycle and recovers the entire data in a preferred location. It is easy to use and compatible with both Windows as well as Mac operating system. This supports the entire Excel versions and the demo version is free.

 

Excel Repair for Windows     Excel Repair for Mac

 

Steps to Utilize MS Excel Repair Tool:

 

g1
g2
g3
g4
g5
g6
g7

Conclusion:

 

Well, this is all about how to recover macros from corrupted Excel.

Well, Macros is a important function of Excel and this makes the work easy for the users also.

And if the Excel file is corrupted recovering this will make the work easy for you.

So, here I have tried my best to share with you the easy methods to recover macros from corrupted workbook easily.

Additionally, Excel is an essential application and used in daily life, so it is recommended to handle the Excel file properly and follow best preventive steps to protect your Excel files from getting corrupted.

Despite it, always create a valid backup of your crucial Excel data and as well scan your system with good antivirus program for virus and malware infection.

If, in case you have any additional questions concerning the ones presented, do tell us in the comments section below or you can also visit our Repair MS Excel Ask Question

Good Luck….



Summary
7 Working Solutions to Fix Excel Opening Files To A Blank Screen
Article Name
7 Working Solutions to Fix Excel Opening Files To A Blank Screen
Description
Facing Excel opening blank screen or won't open a white or grey screen appears, then this article is for you. Here check out the complete solutions to get rid of this irritating issue and access you workbook again...
Author
Publisher Name
Repair MS Excel Blog
Publisher Logo
7 Working Solutions to Fix Excel Opening Files To A Blank Screen