Are you the one facing the issue Excel opens but the spreadsheet won’t open or a blank screen appears only? Sometimes it happens that the Excel file appears blank with no cells, no column or rows names, and no grid lines.
Do you have any idea why this happens or how to make your Excel back to normal again? Well if not, then keep reading this post you will get an answer to all your queries.
Hi all, After I upgraded Word 2016 to version 0900 on my Mac I am now opening every document (attachments in Outlook, files on my desktop etc.) as a blank file. I can see that the header is correct so it seems to be opening the correct file, but the page is blank. It’s often hard to get started on a creative project when you’re staring at a sea of white. Check out Microsoft blank templates for inspiration. There are templates for storyboards, staff paper for songs—even book cover templates and magazine templates. It’s amazing how fast your juices will flow once you find the right framework.
Here in this article, I will give you the best fixes to resolve Excel opens blank or Excel file opens blank grey screen. Moreover, you will also get complete detail about this Excel open blank issue.
Outlook for Mac support tools. 11/4/2019; 3 minutes to read; S; C; A; Applies to: Outlook for Mac for Office 365; In this article Summary. This article describes some useful tools for Microsoft Outlook for Mac. When you double-click an icon or file name for a Microsoft Excel workbook, Excel starts and then displays a blank screen instead of the file that you expect to see. Try the following options to help recover your document. Select the image or header to see more detailed instructions about that option. Office for Mac that comes with a Microsoft 365 subscription is updated on a regular basis to provide new features, security updates, and non-security updates. The following information is primarily intended for IT professionals who are deploying Office for Mac to the users in their organizations.
Why Is My Excel File Opening Blank?
Excel Opening Blank is a very irritating issue usually faced by the Excel users while trying to open their Excel 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 installing the security upgrade.
The security updates KB3115322, KB3115262 & KB3170008 in Excel made changes in certain types of files and the way they open. When the users try to open HTML or XLA files with an Excel .xls extension, then the program would caution over detachment between files and contents however opens without Protected View security.
Microsoft For Mac
And after installing the security updates, the program won’t open workbooks but show a blank screen, because the files become incompatible with the program’s Protected View feature. There is no warning message appears related to the issue.
Similar Issues Related ToExcel Open Blank Screen Issue:
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 files 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 generally by the users when there Excel files opening blank. If in case your Excel files deny to get open and showing ‘Excel Cannot Open The File ‘(Filename)’.Xlsx’ Error.
Check out this helpful post on: ‘Excel Cannot Open The File ‘(Filename)’.Xlsx’ Error.
So, here check out the working solutions to Fix Excel Opens Blank Issue and simply access your workbook.
How To Fix Excel Opens Blank Issue?
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 when the Excel file opens blank grey screen and white screen issue. So, try them in your respective case.
Solution 1: Un-check the Ignore DDE Box
One obvious reason or getting the 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 a file or workbook that has been double-clicked to open.
Follow the steps to do so:
- Open Excel program
- If a new workbook open go to File >Options >Advanced> locateGeneral 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.
Microsoft Office For Mac Pro
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 the white screen appears and access your Excel file easily.
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 Excel programs not to open files.
- Excel add-in
- COM add-in
So turn off Excel 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 not 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 tocontact 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 sorts 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 systems. This supports the entire Excel versions and the demo version is free.
Steps to Utilize MS Excel Repair Tool:
Conclusion:
Microsoft Office For Mac
After reading the complete fixes, I am very much sure that you can fix Excel opening blank issues on your own. At last, I want to conclude that, Excel file opens blank grey screen issue is also conquered due to wrong changes in the Excel settings. That is mainly done for avoiding external programs. So, it’s my recommendation to carefully follow the above fixes.
Good Luck….
You May Also Read:
Margret
Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to understand language is very impressive. When not writing, she loves unplanned travels.