- \n
- Change Excel file format<\/a><\/li>\n
- Repair the Excel file<\/a><\/li>\n
- Set Calculation to Manual<\/a><\/li>\n
- Use Macro to Extract Data<\/a><\/li>\n
- Use Excel recovery tool<\/a><\/li>\n<\/ul>\n
Using Microsoft Excel, you can create digital spreadsheets; a digital spreadsheet is a grid consisting or thousands of cells arranged both horizontally & vertically in which rows are numbered, and columns are assigned with letters respectively.<\/p>\n
Doing so much is possible in spreadsheets with Excel. You can add or create functions, do macro programming, create charts, etc. And by installing Add-ins, additional functionality can be added to enhance the usability.
\nBut does this smooth flow rest for long? According to many, answering the question has been a job with frustration and panic. While you work on the Excel spreadsheet, you may encounter an error message and it can either crash the whole application or the data inside would be gone.<\/p>\nThough Microsoft has their tech forums & FAQ sites both to answer general user queries and help in sorting the issue out, the process of fixing an issue with Microsoft Excel is quite complex. And usually, most of the users end up messing the Excel file and lose the spreadsheet data.<\/p>\n
![\"rips](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefsubbanner.jpg\")
<\/p>\nUsers search quite a lot on the Internet to find ways of recovering either corrupt Excel file(s) or the data it contains. Thus, addressing the same, we\u2019ve come up with a couple of methods which can help you in recovering the corrupt excel file or recover the data it packs.<\/p>\n
Change Excel File Format<\/h4>\n
Excel spreadsheet that was created on a different machine using an older version of MS Excel might become unusable or inaccessible in a newer Excel version. In that case, changing the file format would solve the problem.
\nFor newer Excel spreadsheets the format is XLSX, and for older the format it is XLS. So, for recovering the inaccessible Excel file, you can change the XLSX format to XLS and vice-versa.<\/p>\nGo through the following steps:<\/h4>\n
- \n
- Open the File Explorer<\/strong>.<\/li>\n
- Move to the folder which contains the corrupt Excel file.<\/li>\n
![\"Move](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi1.jpg\")
\n- Right-click on the file and check the format.<\/li>\n
![\"check](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi2.jpg\")
<\/p>\n- Now that you know the current format of corrupt Excel file right-click on the file again, and select Rename<\/strong>.<\/li>\n
![\"rename](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi3.jpg\")
\n- Change<\/strong> the format to xls<\/strong>, as shown below,<\/li>\n
- Note:<\/strong> In case if the format of the corrupt excel-file you have on your system is xls <\/strong>then, change it to xlsx<\/strong>. Press Enter<\/strong>.<\/li>\n
![\"change](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi4.jpg\")
\nNote:<\/strong> In case if the format of the corrupt excel-file you have on your system is xls then, change it to xlsx<\/strong>.<\/p>\n
- Accept the prompt for the changes to take effect; click Yes<\/strong>.<\/li>\n
![\"Accept](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi5.jpg\")
<\/p>\n- Now, double-click on the file to open it and check if it is opening.<\/li>\n
Note:<\/strong> You can also set the file format to HTML<\/strong> and accept the changes, and in case of HTML extension the file would open in a web browser. Further, the document can be converted into an Excel file by dragging it onto the Excel icon and saving the file as an Excel spreadsheet.<\/ol>\n
Repair the Excel File<\/h4>\n
You can repair the corrupt Excel file using the built-in utility to repair. The corrupt Excel file can only be repaired on a Windows system (if you\u2019re using a Mac, try another method).<\/p>\n
Follow the below steps:<\/p>\n
- \n
- Open Microsoft Excel.<\/li>\n
![\"Open](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi6.jpg\")
\n - Click Open other Workbooks<\/strong> at the bottom left.<\/li>\n
![\"](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi7.jpg\")
Open other Workbooks” class=”alignnone size-full wp-image-2620″ width=”282″ height=”158″><\/p>\n- Click Browse<\/strong> to open the corrupt excel file.<\/li>\n
![\"Browse](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi8.jpg\")
<\/p>\n- Select<\/strong> the corrupt file, click on Drop-down<\/strong> icon on the Open<\/strong> button, select Open and Repair<\/strong><\/li>\n
![\"](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi9.jpg\")
<\/p>\n- A prompt would pop on-screen, click Repair<\/strong>.<\/li>\n
![\"repair](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi10.jpg\")
<\/p>\nNote:<\/strong> If the option Repair<\/strong> is not there, then select Extract Data<\/strong> and choose between Convert to Values<\/strong> or Recover Formulas<\/strong>.<\/p>\n
- Once the recovered file opens after recovery, press CTRL + S<\/strong> to save the file as a new Excel Spreadsheet.<\/li>\n
Note:<\/strong> Do not assign the same name, set a new name for the recovered file.<\/ol>\n
Set Calculation to Manual<\/h4>\n
In Microsoft Excel automatic is the calculation setting by default, but in cases of corruption, you can change the calculation setting from Automatic to Default though, by doing this the spreadsheet would not be recalculated, so it is possible that it may open.<\/p>\n
Perform the following steps:<\/strong><\/p>\n
- \n
- Open Excel<\/strong>.<\/li>\n\n
- Click on File<\/strong> tab and select New<\/strong>.<\/li>\n
![\"select](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi11-1.jpg\")
\n- Under the New<\/strong> section, select Blank Workbook<\/strong>.<\/li>\n
![\"select](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi12.jpg\")
\n- Again, click on File<\/strong> tab and click Options<\/strong><\/li>\n
![\"click](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi13.jpg\")
\n- The wizard would pop open, click on Formulas<\/strong>, under Calculation Options<\/strong> select Manual<\/strong>.<\/li>\n
![\"select](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi14.jpg\")
<\/p>\n- Click Ok<\/strong> to apply the change.<\/li>\n
- Here again, click on File<\/strong> tab and select Open<\/strong>.<\/li>\n
![\"select](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi11.jpg\")
\n- Browse<\/strong> the Excel file which was corrupt; the spreadsheet now will open.<\/li>\n<\/ol>\n
Use Macro to extract Data<\/h4>\n
If you\u2019ve linked a chart to the corrupt Excel Spreadsheet and you can\u2019t access the file due to the issue of corruption, you can try using a macro to extract the chart\u2019s source data (using Visual Basic for Applications macro).<\/p>\n
For using a macro, below are the steps:<\/p>\n
- \n
- Type the macro code available below:<\/li>\n
![\"](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/Excel-macro-script.png\")
<\/p>\n - Paste the macro code in a blank Excel Workbook\/spreadsheet.<\/li>\n
- Double-click on sheet\u2019s tab to rename it -set ChartData<\/strong> as the new name.<\/li>\n
- Select the corrupt Excel file which has the linked Chart to extract the values it contains.<\/li>\n
- Run<\/strong> the Macro Code.<\/li>\n<\/ol>\n
Note:<\/strong>
\nTo run macro code on Windows: Open Excel > File > Options > Customize Ribbon<\/strong>.
\nTo run macro code on Mac: Open Excel > Preferences > Ribbon & Toolbar<\/strong>.
\nInside Customize the Ribbon<\/strong> section under Main Tabs<\/strong>, checkmark Developer<\/strong> check box, and click Ok<\/strong>.<\/p>\nUse Excel recovery tool<\/h4>\n
With the application of the above methods, you can recover corrupt Microsoft Excel file(s). Every method is different, and in case if one did not work for you, try the second method and so on.<\/p>\n
It is possible that even after going through the methods mentioned above the corrupt Excel spreadsheet won\u2019t open, and you will be at the same point from where you\u2019ve started.<\/p>\n
In situations like this, we would recommend you to use an Excel recovery<\/a> tool like Excel File Repair. The tool utilizes a logical and analytical approach to handle corrupt or damaged Excel files and recover the data the Excel file contains inside.<\/p>\n
- Click on File<\/strong> tab and select New<\/strong>.<\/li>\n
- Click Browse<\/strong> to open the corrupt excel file.<\/li>\n
- Move to the folder which contains the corrupt Excel file.<\/li>\n
- Repair the Excel file<\/a><\/li>\n
![\"Download](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2018\/06\/dl-btn-new.png\")
<\/a><\/p>\n![\"excel](\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/01\/ttrcefi16.jpg\")
<\/p>\n