Excel workbooks often demonstrate unanticipated symptoms, especially if you are using graphics (like advanced charts) in your Excel sheets. The Excel file opens blank workbook error may occur if the graphics card of your computer won’t function properly due to problem with hardware acceleration.
Microsoft Excel opens saved Excel file as blank workbook. Sometimes, when a user opens a saved workbook, it is blank. This issue is often caused when Excel’s settings are changed (usually inadvertently) to ignore external programs. To correct this issue, try the following suggestions below.
Following are some solutions you can try to fix the ‘Excel 2016 blank screen when opening file’ problem. Note: Before trying these solutions, make sure that the sheet you’re trying to open is not hidden. To locate hidden sheets in Excel, go to ‘View’ tab and check if the Unhide option is greyed out.
Why is excel not opening my files?
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.
Excel file opens in the wrong program If an Excel file opens in a spreadsheet program other than Excel, or if it opens in an application that cannot display the file, the file association is set incorrectly in Windows. Right-click the Excel file in the File Explorer. In the context menu, select ‘Open With’ and then ‘Choose another app’.
Hence, it won’t open the file you’ve double-clicked on. There is a probability that the Excel File Associations settings are been altered; and hence, your excel file will not open. Try resetting these and check if the Excel opens after the reset.
Why is there a blank screen on my Excel spreadsheet?
More precisely, just a blank grey screen appears instead of the file you expect to see. Such an issue can be caused by something as simple as a messed up Excel ‘ Preferences’ settings or something more complicated like underlying corruption in the workbook.
Why can’t I open a file?
It’s probably because it’s been saved in a file format that this version of Excel doesn’t support. Check the table to see if that’s the case.