Several Excel users have reported about experiencing ‘Excel spreadsheet disappears after opening’ issue. The problem occurs when attempting to open an Excel file by double-clicking on the file icon or name. The Excel file opens blank grey screen.
Figure 1 - Excel Blank Screen
User Instances of ‘Excel Open But Can’t See Spreadsheet’ Issue
Instance 1: The user said that “Excel 2016 opens to a blank screen and everything is greyed out. Ribbons at the top of Excel are also not present”.
Instance 2: The user reported that “Attempting to open a spreadsheet, either by double-clicking the file or by opening Excel, it opens but only a blank Excel window is visible. When trying to save that particular file, Excel behaves as though there is no file open at all and all the file saving options, such as save, save as, print, etc. are greyed out.”
Causes Behind ‘Excel Open But Can’t See Spreadsheet’ Issue & the Solutions Thereof
Following are some of the possible reasons behind the ‘Excel open but can’t see spreadsheet’ issue, along with their solutions:
Cause 1: Excel File is Hidden
You may have saved the Excel sheet as a hidden document.
Solution: Unhide Excel File
Verify if your Excel worksheet is hidden by following these steps:
- In Excel, click the View tab, and then click Unhide.
- A dialog box will pop-up showing the worksheet name that can be unhidden. For instance, below is an image of Unhide box that lists ‘Daily_Reports’ spreadsheet under Unhide workbook.
- Click OK to unhide your Excel sheet.
Figure 2 - Unhide Excel File
Figure 3 – Select and Unhide Excel Workbook
If this fails to work, there’s a possibility that the spreadsheet window pane may have slided to one side of the visible desktop. To bring back the displayed area, click the ‘Arrange All’ option under the View tab. If the issue persists, try the next solution.
Cause 2: Ignore Dynamic Data Exchange (DDE) Option is Enabled
Another reason behind the ‘Excel opens to a blank screen’ issue could be that the “Ignore other applications that use Dynamic Data Exchange (DDE)” checkbox is checked in Excel options.
Usually, when you double-click an Excel file, a DDE message is sent to Excel instructing it to open that particular file. But, if you have the ‘Ignore DDE’ option selected, the DDE message sent to Excel to open a workbook is ignored. As a result, the Excel workbook opens a blank screen.
Solution: Uncheck the Ignore DDE Option
Make sure that the ‘Ignore DDE’ option is unchecked by performing these steps:
- In your Excel window, click File > Options.
- From the left-side of the ‘Options’ window, choose Advanced.
- In ‘Advanced’ window, locate the General section, and then uncheck the “Ignore other applications that use Dynamic Data Exchange (DDE)” checkbox.
- Click OK to apply the changes.
Figure 4 - Select Excel Options
Figure 5 - Excel Options Window
Figure 6 - Uncheck Ignore Other Applications that use DDE
If these steps don’t work, proceed to the next workaround.
Cause 3: Issue within Office Program
Sometimes, problem within your Microsoft Office program might cause Excel to behave oddly and may result in an Excel spreadsheet disappeared issue.
Solution: Repair Office Program
Try repairing your Office program by executing the steps listed below, based on your Windows OS:
For Windows 10:
- Type Settings in the Windows search box.
- Click Settings.
- In ‘Windows Settings’ screen, select Apps.
- In ‘Apps & features’ screen, scroll down to your Microsoft Office program and tap on it, and then click the Modify
- In ‘How would you like to repair your Office programs’ dialog box, select the Online Repairradio button, and then click the Repair
Figure 7 - Windows Settings Screen
Figure 8 - Modify MS Office Program
Figure 9 - Repair MS Office Program
For Windows 8:
- Open Control Panel and click the Uninstall a program option under Programs.
- Select Microsoft Office 365 and then click Change.
- In the window that opens, select Online Repair and then hit the Repair
You may be asked to restart your system after completion of the repair process.
For Windows 7:
- In ‘Control Panel’ window, double-click Programs and Features.
- Under Uninstall or change a program section, select the Office program, and then select Change.
- In the dialog box that appears, choose Online Repair and then choose Repair.
If repairing your Office installation fails to resolve the issue, continue to solution 4.
Cause 4: Problematic Excel and COM Add-ins
Sometimes, Excel and COM add-ins may cause Excel file open a blank grey screen problem.
Solution: Disable the Add-ins
Disabling the Excel and COM add-ins one at a time may help resolve the problem. The steps are as follows:
- Click the File menu in your Excel file and select
- From ‘Excel Options’ left-side panel, click Add-Ins, and then choose COM Add-ins from the ‘Manage’ drop-down. Click the Go
- Uncheck one of the add-ins checkbox from the COM Add-ins window, then select OK.
- Restart your Excel program.
Figure 10 - Select COM Add-ins
Figure 11 - Uncheck and Disable COM Add-ins
If the issue persists, repeat the above steps (1 till 4), except that you need to choose a different add-in in step 3.
If you’re still experiencing the same problem after unchecking all the COM add-ins, repeat all the above steps, except choose ‘Excel Add-ins’ in step 2.
If Excel can load the file, then the add-in that you disabled last leads to the problem. If turning off add-ins does not work, try the next solution.
Cause 5: Problem with Excel File Associations
The Excel file opening a blank screen problem may occur if the file associations are not performing correctly.
Solution: Reset Excel File Associations
Try resetting the file associations in Excel to their default settings. For this, follow the below steps based on your OS.
For Windows 10 and Windows 8.1:
- Select the file that is opening incorrectly and copy it to the desktop.
- Right-click the file and click Properties.
- In the File's 'Properties' window, check your file type next to Type of Filefrom the General tab. For instance, (.docx), (.csv), or (.pdf).
- Next, check to which app your file is associated with from the Opens withoption
If the file type is different than .xlsx, open the file in a different application by following these steps:
- Click the Change button next to the ‘Opens with’ option.
- Click More apps.
- From the list of applications, select the desired app and then check the Always use this app Click OK.
For Windows 8:
- Open Control Panel, click Default Programs, and then select Set your default programs.
- Choose Excel and then tap the Choose default for this program
- In ‘Set Program Associations’ window, choose Select All and then click Save.
For Windows 7:
- In Control Panel, choose Default Programs.
- Click the Associate a file type or protocol with a specific program
- Choose Microsoft Excel Worksheet and click on change program.
- Choose Microsoft Excel under Recommended Programs.
- If you’re unable to find Excel, browse the Excel installation folder.
- Select exe and then choose Excel.
What Next? Use Stellar Repair for Excel to Recover Your File
If the above solutions don’t help recover your Excel file, use an Excel file repair tool, such as Stellar Repair for Excel to recover it. The software can restore the Excel spreadsheet and its components, including tables, pivot tables, charts, formulas, etc. while preserving the spreadsheet properties and formatting.
Check out the video to recover Excel file by using Stellar Repair for Excel software.
Conclusion
This article described the possible causes behind the ‘Excel open but can’t see spreadsheet’ issue, along with their solutions. The manual solutions to resolve the issue require time and efforts. But, if you need to access your Excel file without any delay, use Stellar Repair for Excel software to recover your .xlsx/.xls file in just a few clicks.
7 min read
7 min read
7 min read
