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.