Well, you can do that with Excel—unless Excel shows a blank doc when you open the spreadsheet. Fortunately, there are a few fixes that you can try.
1. Check the File
If you open the file and Excel shows a blank doc, the first thing you should do is check the file. This way, you avoid troubleshooting a problem that doesn’t exist. Open another spreadsheet and see if Excel works as usual. In this case, you should re-download the file or ask the file owner to check the Excel file.
If the file works fine for other people, take a look at its properties. Right-click the spreadsheet and select Properties. In the General tab, check if the file is set to open with Excel. If not, click Change and choose Microsoft Excel from the list.
You can change the default app in Windows to avoid running into the same problem again.
2. Unhide the Sheets
Hiding the document’s sheets is a sneaky way to hide its content if you don’t want to password-protect your Excel file. So if Excel displays a blank document, unhiding its sheets might fix the problem.
Open the spreadsheet, select the View tab, and click Unhide. Then, choose which workbook Excel should unhide and confirm it by clicking OK.
3. Refresh Microsoft Excel
Refreshing Excel might seem like an odd trick, but it might get your spreadsheets visible again. Open the problematic Excel file and click Minimize from the window’s top-right corner. Then, wait a few seconds and click the Excel icon on your taskbar to re-open the file.
4. Turn Off Add-Ins
Until now, we’ve tried to fix the blank Excel files issue without changing Excel settings. But if nothing worked, it’s time we move on to more complicated solutions.
Excel add-ins are designed to extend the app’s functionality as you can use them to add charts not available in Excel by default, add bookmarks to your sheets, or integrate a random number generator, amongst other options.
However, a corrupt or outdated add-in might stop Excel from showing a doc’s content. In this case, you should turn off Excel add-ins.
Launch Excel and head to File > Options. From the left-hand menu, select Add-ins. Set Manage to Excel Add-ins and click Go. Excel will display a list of installed add-ins. To deactivate one of the add-ins, uncheck it and click OK.
5. Disable Hardware Acceleration
The hardware graphics acceleration feature should help Excel display animations or other graphic elements included in the spreadsheet. In reality, it doesn’t make a big difference, and it usually affects Excel’s overall performance, which is why you should turn it off.
In Excel, head to File > Options. Select Advanced. From Display, check the Disable hardware graphics acceleration option. Click OK to save the new settings.
6. Ignore Dynamic Data Exchange
When you open an Excel spreadsheet, your system sends a dynamic data exchange (or DDE) to Excel. If there are multiple programs receiving and using the same DDE, it will confuse your system, and Excel will open a blank document. To prevent it, you should disable DDE for other apps.
In Excel, go to File > Options > Advanced. There, head to General, uncheck Ignore other applications that use Dynamic Data Exchange (DDE), and click OK.
7. Repair Microsoft Office
If you notice that Excel isn’t the only Office app that malfunctions, you should repair Microsoft Office.
Press Windows key + I to bring up Settings. Head to Apps > Apps & features. From the apps list, select Microsoft Office and click Modify. In the pop-up window, select Quick repair and click Repair to start the process.
Fix Blank Spreadsheets
Hopefully, one or more fixes helped you make Excel spreadsheets visible again. Usually, when this happens, you’re dealing with an incomplete download or incorrect file format. So if a coworker sends you an Excel file, open it right away to avoid any future problems.
With Excel working again, you can learn about how to efficiently organize your spreadsheets.