{"id":7796,"date":"2021-07-20T07:20:51","date_gmt":"2021-07-20T07:20:51","guid":{"rendered":"https:\/\/www.kerneldatarecovery.com\/blog\/?p=7796"},"modified":"2021-07-20T11:26:53","modified_gmt":"2021-07-20T11:26:53","slug":"fix-excel-file-wont-open-error","status":"publish","type":"post","link":"https:\/\/www.kerneldatarecovery.com\/blog\/fix-excel-file-wont-open-error\/","title":{"rendered":"How to Fix MS Excel file won\u2019t open"},"content":{"rendered":"
Many a time, while opening your Excel file, you might come across an issue, \u201cExcel file won\u2019t open.\u201d You might notice a blank sheet instead of the file supposed to be opened. This is a common issue, and in this article, we will come across simple ways by which you can resolve this.<\/p>\n
There can be some possible reasons as to why you are not able to access your Excel file. Some of them are listed below:<\/p>\n
\n
Excel file you want to open is corrupt.<\/li>\n
Excel application is corrupt.<\/li>\n
Excel application is unable to communicate with other applications.<\/li>\n
The file association is broken.<\/li>\n<\/ul>\n
How to fix the Excel file won\u2019t open issue?<\/strong><\/p>\n
To solve the problem manually, you will have to try different solutions to see which suits the best. Below are some of the ways that can be used to resolve the issue.<\/p>\n
Method 1: Uncheck the Ignore DDE box<\/strong><\/p>\n
This is one of the easiest ways to resolve the issue. The default setting of Dynamic Data Exchange (DDE) is disabled. The Excel file will not open if, by any chance, this setting is enabled. Below are the steps to fix the DDE issue:<\/p>\n
Step 1: Open the Excel file from the Start menu.<\/p>\n
Step 2: Click on the File<\/strong> tab.<\/p>\n
Step 3: Select Options<\/strong>. \n<\/p>\n
Step 4: Under the Options dialogue box, select the \u2018Advanced\u2019 option on the left pane.<\/p>\n
Step 5: Under the General section, ensure that the dialogue box, \u2018Ignore other applications that use Dynamic Data Exchange (DDE)\u2019 is disabled.<\/p>\n
Step 6: Close the Excel Options dialogue box.<\/p>\n
Method 2: Check Hide\/Unhide<\/strong><\/p>\n
If you wish to open a particular file, it might happen that the file is open but it is hidden. In that case, you need to follow few steps mentioned below:<\/p>\n
Step 1: Open the Excel application.<\/p>\n
Step 2: Click on the View <\/strong>tab.<\/p>\n
Step 3: Under the Window section, check if the Hide<\/strong> option is selected.<\/p>\n
Step 4: If it is so, select the Unhide<\/strong> option.<\/p>\n
Step 5: Select the file you want to view and click OK.<\/p>\n
Method 3: Disable Add-ins<\/strong><\/p>\n
Add-ins might cause a conflict with the Excel application. Although they boost the Excel functionality and allow the use of many Excel features, they can turn out to be problematic at times. You can manually fix this issue by following these steps:<\/p>\n
Step 1: Open the Excel file from the Start menu.<\/p>\n
Step 2: Go to the File<\/strong> tab and select Options<\/strong>.<\/p>\n
Step 3: Under the Options tab, select the \u2018Add-ins\u2019 option on the left pane. \n<\/p>\n
Step 4: At the bottom of the Add-ins dialogue box, select the Manage<\/strong> drop-down.<\/p>\n
Step 5: Select COM Add-ins and click on Go<\/strong>. \n\n<\/p>\n
Step 6: Below the COM Add-ins dialogue box, disable all the add-ins dialogue boxes.<\/p>\n
It might happen that the settings of the Excel File Associations are being altered. In that case, the Excel file will not open. You can reset the settings by following the below steps:<\/p>\n
Step 1: Open Control Panel<\/p>\n
Step 2: Select Programs<\/strong>. \n\n<\/p>\n
Step 3: Click on Default Programs<\/strong><\/p>\n
Step 4: Under Default Programs, select \u2018Set your default programs.\u2019 \n\n<\/p>\n
Step 5: Locate and click on the Excel application in the left pane.<\/p>\n
Step 6: Select \u2018Choose defaults for this program.\u2019<\/p>\n
Step 7: Check the Select All<\/strong> box.<\/p>\n
Step 8: Click on Save and OK. This will reset all your Excel File Association settings.<\/p>\n
Method 5: Repair Microsoft Office<\/strong><\/p>\n
There might be some issue with Microsoft Office which could be the reason behind your Excel file not opening. Follow the steps below to solve this procedure.<\/p>\n
Step 1: Hold the Windows key and press R key. Run dialogue box will open.<\/p>\n
Step 2: Enter the text, \u2018appwiz.cpl<\/em>\u2019 in the run box. \n\n<\/p>\n
Step 3: Now, locate Microsoft Office. \n\n<\/p>\n
Step 4: Right-click on Microsoft Office option and click on Change<\/strong>. \n\n<\/p>\n<\/figure>\n\n\n
Step 5: In the dialogue box, select Quick Repair<\/strong>.<\/p>\n\n\n\n
Step 6: Click on the Repair<\/strong> button.<\/p>\n\n\n\n
Hardware Graphic Acceleration helps in boosting the performance while working with Microsoft Office Applications. But sometimes, this can also cause an error in opening your Excel file. Below are the steps to resolve the issue via this method:<\/p>\n\n\n\n
Step 1: Open the Excel application and click on the File<\/strong> tab.<\/p>\n\n\n\n<\/a><\/figure>\n\n\n\n
![\"Open](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss1.jpg\")
<\/p>\n![\"Select](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss2.jpg\")
<\/p>\n![\"select](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss3.jpg\")
<\/p>\n![\"Ignore](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss4.jpg\")
<\/p>\n![\"Open](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss5.jpg\")
<\/p>\n![\"Select](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss6.jpg\")
<\/p>\n![\"select](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss7.jpg\")
<\/p>\n![\"Select](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss8.jpg\")
\n<\/p>\n![\"Select](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss9.jpg\")
\n<\/p>\n![\"Set](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss10.jpg\")
\n<\/p>\n![\"Run](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss11.jpg\")
\n<\/p>\n![\"locate](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss12.jpg\")
\n<\/p>\n![\"Change](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss13.jpg\")
\n<\/p>\n![\"Open](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss16.jpg\")
<\/a><\/figure>\n\n\n\n![\"select](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss17.jpg\")
<\/a><\/figure>\n\n\n\n![\"Disable](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/07\/ss14.jpg\")
<\/p>\n\n\n\n\n\n