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.
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.
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:
- 6 Working Solutions to Fix “Unable To Save Excel File 2007” Error
- 5 Methods to Fix “Problem With Some Content in Excel 2013” Error
- Solved: MS Excel Cannot be Opened or Repaired
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.
Steps to Utilize MS Excel Repair Tool:
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