{"id":87191,"date":"2020-10-14T06:39:35","date_gmt":"2020-10-14T06:39:35","guid":{"rendered":"https:\/\/www.isunshare.com\/blog\/?p=87191"},"modified":"2020-10-29T01:03:39","modified_gmt":"2020-10-29T01:03:39","slug":"solved-microsoft-excel-file-is-corrupted-and-cannot-be-opened","status":"publish","type":"post","link":"https:\/\/www.isunshare.com\/blog\/solved-microsoft-excel-file-is-corrupted-and-cannot-be-opened\/","title":{"rendered":"Solved-Microsoft Excel File is Corrupted and Cannot Be Opened"},"content":{"rendered":"<p>Microsoft Excel helps us to deal with the data and make intuitive and effective reports. Everyone is very familiar with MS Excel functions. But when it comes to the warning message that tells the file is corrupted and cannot be opened, many people do not know how to rescue the valuable data in MS Excel. No matter it is MS Excel 2007\/2010\/ 2013\/2016 or even 2019, you can find ways to fix the problem that the <strong>Microsoft Excel file is corrupted and cannot be opened<\/strong>. In this article, 3 possible ways are discussed below.<\/p>\n<ul>\n<li><a href=\"#way1\">Way 1: Disable Protected View in Trust Center<\/a><\/li>\n<li><a href=\"#way2\">Way 2: Change Component Service Settings<\/a><\/li>\n<li><a href=\"#way3\">Way 3: Repair Corrupt Excel File with iSunshare Excel Repair Genius<\/a><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"396\" class=\"size-full wp-image-87192 aligncenter\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/solved-microsoft-excel-file-is-corrupted-and-can-not-be-opened.png\" alt=\"solved--Microsoft Excel file corrupted and cannot be opened\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/solved-microsoft-excel-file-is-corrupted-and-can-not-be-opened.png 680w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/solved-microsoft-excel-file-is-corrupted-and-can-not-be-opened-300x175.png 300w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/p>\n<h2 id=\"way1\">Way 1: Disable Protected View in Trust Center<\/h2>\n<p>It is said that when you upgrade the Microsoft Excel, the protected view settings will change automatically. And for this reason, the Excel file would be corrupt and cannot be opened. Thus, you need to disable the protected view option in trust center of MS Excel.<\/p>\n<p><strong>Step 1:<\/strong>\u00a0 Launch your Microsoft Excel program and then click File &gt; Options.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"406\" class=\"alignnone size-full wp-image-87193\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/excel-file-option.png\" alt=\"click Option button \" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/excel-file-option.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/excel-file-option-300x203.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Click Trust Center from the left menu on the Excel Options interface.\u00a0 After that, click the Trust Center Settings button under the Microsoft Excel Trust Center field.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"340\" class=\"alignnone size-full wp-image-87194\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/click-trust-center-settings.png\" alt=\"click trust center settings\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/click-trust-center-settings.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/click-trust-center-settings-300x170.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><strong>Step 3:<\/strong> In the Trust Center interface, choose Protected View from the left menu. In no time, you can get the details for the Protected View. Then, uncheck all the options under the Protected View field. Finally, click the OK button to save the changes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"489\" class=\"alignnone size-full wp-image-87195\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/uncheck-protected-view-option.png\" alt=\"uncheck Protected view options\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/uncheck-protected-view-option.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/uncheck-protected-view-option-300x245.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>After that, you can try to open the Excel file again. If you successfully access the Excel file data, the message \u201cThe Excel file corrupted and cannot be opened\u201d will not appear. It means you get the issue fixed.\u00a0 Otherwise, you can continue to try other methods.<\/p>\n<h2 id=\"way2\">Way 2: Change Component Service Settings<\/h2>\n<p>You can change the Component Service settings to solve the Excel file corrupted issue.<\/p>\n<p><strong>Step 1:<\/strong>\u00a0 Press the Windows key and R key on your keyboard to start the Run dialog. After that, enter \u201cdcomcnfg\u201d and click the OK button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"427\" height=\"235\" class=\"alignnone size-full wp-image-87196\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/run-dcomcnfg.png\" alt=\"run dcomcnfg\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/run-dcomcnfg.png 427w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/run-dcomcnfg-300x165.png 300w\" sizes=\"auto, (max-width: 427px) 100vw, 427px\" \/><\/p>\n<p><strong>Step 2:\u00a0<\/strong> Then you are on the Component Services window. You need to double click on the Component Services and then the Computers option on the left panel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"341\" class=\"alignnone size-full wp-image-87197\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/double-click-computer.png\" alt=\"get computer option\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/double-click-computer.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/double-click-computer-300x171.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Right-click on My Computer and select the Properties option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"285\" class=\"alignnone size-full wp-image-87198\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/right-click-my-computer.png\" alt=\"right click on My Computer\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/right-click-my-computer.png 580w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/right-click-my-computer-300x147.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/p>\n<p><strong>Step 4:<\/strong>\u00a0 On My Computer Properties window, you need to tap the Default Properties. Afterward, set the Default Authentication Level to Connect and change the Default Impersonation Level to Identify. At last, click the OK button to apply the change.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"416\" class=\"alignnone size-full wp-image-87199\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/change-default-authentication-level-and-default-impersonation-level-settings.png\" alt=\"change default properties settings\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/change-default-authentication-level-and-default-impersonation-level-settings.png 300w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/change-default-authentication-level-and-default-impersonation-level-settings-216x300.png 216w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<h2 id=\"way3\">Way 3: Repair Corrupt Excel File with iSunshare Excel Repair Genius<\/h2>\n<p>There is a much easier way for you to rescue the corrupted Excel file\u2014use the Excel repair tool. <a href=\"https:\/\/www.isunshare.com\/excel-repair-genius\/\">iSunshare Excel Repair Genius<\/a> is a professional Excel\u00a0 XLSX file repair tool that enables users to quickly fix corruption errors in Excel XLSX file without any change in the original data and other elements. It is extremely easy to repair corrupt excel file with this software. You can check the details below.<\/p>\n<p><strong>Step 1:<\/strong> Run the software immediately after you install it on your computer. You can <a href=\"https:\/\/www.isunshare.com\/downloads-v2016\/isunshare-excel-repair-genius.exe\">free download<\/a> from iSunshare official website.<\/p>\n<p><strong>Step 2:<\/strong> Click the Open button to choose your XLSX file for repairing. After that, click the Restore button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"370\" class=\"alignnone size-full wp-image-87200\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/choose-your-excel-file-to-repair.png\" alt=\"choose your excel file to repair\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/choose-your-excel-file-to-repair.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/choose-your-excel-file-to-repair-300x185.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><strong>Step 3:<\/strong>\u00a0 The excel .xlsx file content will be recovered instantly. And when you get the pop-out box, click the OK button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"368\" class=\"alignnone size-full wp-image-87201\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/the-corrupted-excel-file-is-restored.png\" alt=\"the corrupted excel file is restored\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/the-corrupted-excel-file-is-restored.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/the-corrupted-excel-file-is-restored-300x184.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><strong>Step 4:<\/strong> To preview the repaired excel content, you need to save the restored file to your local computer. Just go to click the Save button and select a location to store the file.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"370\" class=\"alignnone size-full wp-image-87202\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/save-the-restored-excel-file.png\" alt=\"save the restored excel file\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/save-the-restored-excel-file.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/save-the-restored-excel-file-300x185.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><strong>Step 5:<\/strong>\u00a0 In minutes, the file is saved successfully. You can open to view the data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"370\" class=\"alignnone size-full wp-image-87203\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/new-file-is-saved-successfully.png\" alt=\"save restored file successfully\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/new-file-is-saved-successfully.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2020\/10\/new-file-is-saved-successfully-300x185.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<hr \/>\n<p><strong>Related Articles: <\/strong><\/p>\n<ol>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/remove-restrict-editing-in-excel-without-password.html\">How to Remove Restrict Editing in Excel without Password<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/remove-or-disable-read-only-in-excel-file\/\">How to Remove or Disable Read Only in Excel File <\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/open-password-protected-excel-file-worksheet-without-password.html\">How to Open Password Protected Excel File Worksheet without Password<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel helps us to deal with the data and make intuitive and effective reports. Everyone is very&#8230;<\/p>\n","protected":false},"author":1,"featured_media":87192,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-87191","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-documents"],"_links":{"self":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/87191","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/comments?post=87191"}],"version-history":[{"count":2,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/87191\/revisions"}],"predecessor-version":[{"id":87223,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/87191\/revisions\/87223"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media\/87192"}],"wp:attachment":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media?parent=87191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/categories?post=87191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/tags?post=87191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}