albumhost.blogg.se - Excel files open blank 2013

Excel files open blank 2013 software#

Do not interrupt it before it is completed.Īlso read: Excel AutoRecover not Working, What is Next? Solution 6: Repair Blank Excel Workbook with Excel Repair Software Note: This process can take a little time to complete. Select ‘Microsoft Office’ in the programs list and then click the Repair option.Open Control Panel and select Programs and Features.Try repairing it using the following steps: 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. 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.