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. Figure 1 – Excel 2016 Blank Workbook 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.
