If the above solutions fail to resolve the issue, your MS Office installation might be damaged. Solution 5:В Repair MS Office Installation In the вЂSet Program AssociationsвЂ™ window, click on Select All and then hit the Save button.Select Excel from the list of default programs and then click вЂChoose default for this programвЂ™.Click on вЂSet your default programsвЂ™ to open currently installed programs.This will open the вЂExcel OptionsвЂ™ window. In Microsoft Excel, click on File > Options.So check the value of this setting and uncheck the вЂњignore DDEвЂќ option (if enabled).

If the DDE message is set to be вЂњignoredвЂќ in Excel, double-clicking a workbook will open a blank screen. When a user double-click an Excel workbook in Windows, a dynamic data exchange (DDE) message is sent to the Excel application, instructing it to open that workbook. Solution 2: Uncheck the вЂIgnore DDEвЂ™ Option Note: The solution might help you regain access to the file data but the problem may persist. If it opens, copy and paste the file data to a new workbook. For this, start Excel and click File > Open > Computer > Browse to locate the file. Instead of clicking on the file name to open Excel spreadsheet, try opening it from Excel.

Solution 1:В Copy the Data to a New Workbook To locate hidden sheets in Excel, go to вЂViewвЂ™ tab and check if the Unhide option is greyed out.

Note: Before trying these solutions, make sure that the sheet youвЂ™re trying to open is not hidden. Solutions to Fix the вЂExcel 2016 Opening Blank WorkbookвЂ™ IssueДЇollowing are some solutions you can try to fix the вЂExcel 2016 blank screen when opening fileвЂ™ problem.

Solutions to Fix the вЂExcel 2016 Opening Blank WorkbookвЂ™ Issue.

Excel files open blank from email