Moreover, these methods make significant changes to your system, which makes it more vulnerable to possible security threats. These methods won’t work if the excel files are corrupted or damaged. Go to the Default Properties tab and make the following changes:īoth “Changing the Protected View Settings” and “Changing the Component Services Settings” are applicable if the excel files are free from any corruption. Step 3: Right-click on My Computer and select Properties. Step 2: Go to the Navigation Pane and expand the Component Services directory. Type “dcomcnfg” and hit Enter or click OK. Step 1: Press Win + R to launch the Run Command dialog box. Therefore, be careful while following the steps given below.
xlsx after you access it, then enable the “Protected View Settings.”Ĭhanging the Component Services Settings means you are making changes to your Windows registry. Therefore, it is recommended to save your document with new office extension like. Note: Disabling the Protected View Setting can make your system vulnerable to external threats and intrusions. Now, restart Microsoft Excel on your system and try to open the broken excel file again. Step 4: In the Trust Center window, select the Protected View Tab and uncheck all options under the Protected View section. Step 3: Select Trust Center > Trust Center Settings. Step 1: Launch Microsoft Excel on your system.Īn Excel Options window will appear on your screen. To change the Protected View Settings, follow the steps given below: Version change can lead to the changes in preview settings in Excel. Disable Protected View Settings in Excel.In this article, we will discuss some of the most popular workarounds for inaccessibility of Excel files. However, the main question here is how to recover corrupt excel files in our system. The reason behind the inaccessibility of an excel file can range from corruption to the use of a different version of the Microsoft Office platform.įor instance, when you try to open a file created in Excel 2007 in Excel 2010, you will get an error saying – “The file is corrupt and cannot be opened.” This situation may not be associated with the corruption of the excel file instead, it could have just happened due to the differences in the default settings of different versions. Users may encounter scenarios where they are unable to access their excel files. Just like other file formats, excel files are also prone to corruption.
It provides a range of different functions, graphs, and smart charts with which we can make effective reports on various uses of our personal as well as professional life. Excel is one of the major components of the Office suite, designed and developed by Microsoft.
0 kommentar(er)
