,
If you try to open an Excel file and Excel opens but the worksheet is blank, continue reading below to fix the problem.
Problem in details: Excel opens a blank screen when you double-click any Excel document to view/edit it (as in the screenshot below). Simply put, Excel starts but does not display the contents of the worksheet (Excel workbook/worksheet is blank/empty).
How to FIX: Microsoft Excel opens a blank document in any Excel file.
Method 1. Unhide Excel Workbook.
The first method to fix the mentioned problem, is to unhide the contents of the Workbook. To do that:
1. Select the View tab and click the Unhide option if active.
2. Then click OK to unhide the workbook.
3. If you can see now the contents of the Workbook, click Save and continue your work.
Method 2. Arrange Windows of Active Workbook.
1. Select the View tab and click Arrange All (if active).
2. On the “Arrange Windows?” window, check the Windows of active workbook checkbox and click OK.
3. If you can see now the contents of the Workbook, click Save and continue your work.
Method 3. Disable the Hardware Acceleration from Excel Options.
Another method to fix the blank screen problem in Microsoft Excel, is to disable the hardware acceleration. To do that:
1. From File menu click Options.
2. Select Advanced on the left and then on the right scroll down to find the ‘Display‘ options and check the Disable hardware graphics acceleration box.
3. When done, click OK and check if the issue is fixed. If, not undo the change and continue to next method.
Method 4. Reset Microsoft Excel to Default Settings.
Another reason why Excel displays a blank screen when opening a Workbook, is an incorrect setting. Therefore, proceed to reset the Microsoft Excel settings to their defaults using the procedure below:
+ R keys to load the Run dialog box.
2. Type regedit and press Enter, to open the Registry Editor.
3. In the Registry Editor, navigate to the following path according to your Excel/Office version:
- Office 2007: HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0Excel
- Office 2010: HKEY_CURRENT_USERSoftwareMicrosoftOffice14.0Excel
- Office 2013: HKEY_CURRENT_USERSoftwareMicrosoftOffice15.0Excel
- Office 2016, 2019 & Office 365: HKEY_CURRENT_USERSOFTWAREMicrosoftOffice16.0Excel
4. Now, double-click at Excel key to expand it and then right-click on the Options key and select Delete. Click Yes to to confirm your decision and close the Registry editor.
5. Now open any Excel document and check if the problem is fixed.
Method 5. Repair Microsoft Office.
The next method to resolve the Excel bank document issue, is to repair the Office installation by following the steps below:
1. Simultaneously press the Windows
+ R keys to open run command box.
2. In run command box, type: appwiz.cpl and press Enter.
3. In Programs and features, select the Office version you have installed, and click Change.
4. Leave the Quick Repair option selected and click Repair.
5. When the Office repair process is completed, launch any Office application and see if the problem persists. If so, then follow the same steps but this time select the Online Repair option. *
* Note: The “Online Repair” process, will remove and then will reinstall all the Office applications on your PC.
Method 6. Completely Uninstall & Re-Install Microsoft Office.
The final method to solve the blank screen problem in Excel is to uninstall and reinstall MS Office.
1. Close all Office programs.
2. Download Microsoft’s Office Uninstall support tool utility (Source).
3. Double-click to run the downloaded SetupProd_OffScrub.exe file and then click Install.
4. Choose I Agree at License Agreement and then let the Troubleshooter to find the installed MS Office products.
5. At Uninstall Office Products, select to uninstall all Office products and click Next.
6. When the Office uninstallation is complete, restart your computer.
7. Finally, proceed to install Microsoft Office again. *
* Notes:
1. To install Office 2019, 2016 or Office 2013, follow these instructions: Download and install or reinstall Office 2019, Office 2016, or Office 2013
2. To install Office 365 or Office 2019, follow these instructions: Download and install or reinstall Microsoft 365 or Office 2021 on a PC or Mac.
That’s it! Which method worked for you?
Let me know if this guide has helped you by leaving your comment about your experience. Please like and share this guide to help others.