After saving a workbook one day, you may open it the next day and find that Excel moves you to a blank workbook. Read this IR Cache blog to understand what causes such a problem. Also, find solutions to the “Microsoft Excel 2016 that Opens a Saved File as Blank” problem.
`Microsoft Excel 2016 that Opens a Saved File as Blank Workbook/Empty Spreadsheet’ is a common problem that users encounter when trying to open an Excel file. The error can be caused by something simple, such as a misconfigured Excel, or something more complex, such as a corrupt workbook. Whatever the cause, you can fix it with a few simple solutions.
Why does Microsoft Excel 2016 open a saved file as blank in Windows 10?
The problem can be caused by several reasons. In the following list, we have listed the ones that most often cause the problem.
Damaged Microsoft Excel installation: In most cases, the problem is caused by a damaged Microsoft Excel installation. In such cases, you can easily fix the problem by repairing your installation.
Startup Options: Microsoft Excel startup options can also be the cause of this problem. The folder where startup settings are stored is often the cause of these problems.
Microsoft Excel settings: The last item is the Microsoft Excel settings. These include DDE, hardware acceleration, etc. These options usually cause problems, but they can be easily fixed.
Now that you have a basic understanding of the possible factors of the problem, you can begin to fix it.
To solve this problem, please follow the solutions below in the order given to get a quick fix.
How do I fix a Microsoft Excel 2016 error that opens a file saved as blank on Windows 10?
Reset the file associations in Excel
One solution to this problem is to reset file associations in Excel to default settings. To do this, simply follow these instructions:
- Open the Control Panel.
- Click on Programs, then select Default Programs.
- Select Set Defaults by Application.
- Select Excel from the list of default programs.
- Click on “Choose a default value for this program”.
- When the Set Program Assignments screen appears, click the checkbox next to Select All.
- Click Save, and then click OK.
Disabling Ignore DDE
Excel may not open files correctly because of the Dynamic Data Exchange (DDE) feature. When you double-click a file, it should send a message to the program to open the workbook. In this case, you need to uncheck the Ignore DDE option to solve the problem.
- Open Excel and go to the File tab.
- Click the Options button.
- Once the Options window is open, go to the left side menu and click Advanced.
- Scroll down to the General section.
- Make sure that “Ignore other applications that use Dynamic Data Exchange (DDE)” is unchecked.
- Click OK and close Excel.
- Double-click the file you want to open and make sure the error is fixed.
Disable Hardware Graphics Acceleration
Sometimes the hardware-accelerated charts feature causes Excel to hang or crash. It can also cause you to see only a blank screen when you double-click on .xls files. Therefore, we recommend that you disable this feature by following the instructions below:
- Open Excel and click the File tab.
- Click on Options, then go to the left-hand menu and select Advanced.
- Scroll down until you see the View section.
- Make sure the Disable Graphics Hardware Acceleration checkbox is selected.
- Click OK, then close Excel.
- Double-click the Excel file you want to open and verify that this method fixed the error.
Repairing Microsoft Office
In some cases, the best solution is to repair Microsoft Office programs. Simply follow the instructions below:
- Start Control Panel.
- Select Programs, then click Uninstall Program.
- Scroll down the list until you find Microsoft Office.
- Click it, then choose Edit from the pop-up menu.
- Click Online Repair, then select Repair.
- Once the process is complete, restart your computer.
- Double-click the Excel file you want to open, then make sure the error is fixed.
Frequently Asked Questions
- Launch the Microsoft Excel program.
- Choose File -> Preferences.
- Go to the Advanced section.
- On the page that opens, find the General settings group. You will find it at the bottom of the page.
- Make sure that the option "Ignore other applications that use Dynamic Data Exchange (DDE)" is unchecked.
- Click File -> Options -> Advanced.
- Under General, uncheck Open all files on startup, then click OK.
- In Windows Explorer, remove any icon that launches Excel and automatically opens the workbook from the alternate startup folder.
The "Excel file opens blank workbook" error may occur if your computer's video card is not working properly due to a hardware acceleration issue.
Excel may not open files correctly because of the Dynamic Data Exchange (DDE) feature. When you double-click on a file, it is assumed that the program sends a message to open the workbook. In this case, you need to disable Ignore DDE to solve the problem.