Any way to repair severely corrupted excel file

Dear Friends,


I had by mistakenly Shift+ Del my excel document which was of high importance. I tried to recover the file using a software and I got the file back, but when I am trying to open the file. It shows the corrupted file error message. Can anyone please help me on this issue.

The original file is most likely not recoverable.

When you (permanently) delete a file, the disk area(s) used by the file are marked as 'free' and can be used by the operating system to store other information. If any area previously occupied by the file has been overwritten then there's no chance of recovering the original data. If it is possible to recover a file it is essential this is done as soon as possible. The longer the file is 'deleted' the greater chance some of the contents will be overwritten so the one overriding thing is the sooner you try to recover a file the better.

That's a general overview - forensic techniques can recover data after a disk has been formatted but that's a little out of this league. However, there is a chance a copy of the file might still be in the Temporary directory - have a read of this, if you haven't already.

I need your help Sir if you could recover this File

Chronology : I was trying to open this CSV and separate the data, by changing the unicode and the Separate Options. But after i clicked "Ok", the data is empty. And when i opened the file, it says “File format and extension of [filename] don't match. The file could be corrupted or unsafe”.

Please help.
I will attached the file and the settings before everything happens.

.
.
I can't vouch for any of these tips 'cuz I've never used them. However, here are some suggestions from others that apparently worked for them :

RESTORE CORRUPT FILE

Restoring a Corrupted File
This is the reply from one of members re restoring a corrupted file

The techs at Microsoft were able to restore the Excel file!

I'm not sure what all they did (some of it was magic, evidently), but here's a tip they passed along.

If you're having a problem with an Excel file, save it as HTML (which is one of the file types in Excel), then save it back to .xls

They say that will often recover lost information, or restore a corrupt file.
=================================================================================

http://directory.s2services.com/excel.htm
=================================================================================

https://support.office.com/en-us/article/Repair-a-corrupted-workbook-153A45F4-6CAB-44B1-93CA-801DDCD4EA53
=================================================================================

Another way of restoring broken/corrupted Excel files
I've been quite lucky actually opening corrupted files in OpenOffice, saving them, and then re-opening them in Excel. Sometimes the formatting will be a little off, 
but the data is almost always recovered, as well as most of the formatting. Unfortunately, not all of the formula and charts are, but when it happened I was happy 
anything was salvaged at all :-)

https://support.office.com/en-us/art...#_Toc337637262

Dear Lagel,

The main issue with the file is that I had deleted it once and now I have recovered it using a recovery software. I have the excel file now which says "Not Supported Format, blah blah".

You said about the macro, Do you have any idea about the same ?

Dear Avk,

I have deleted the file using Shift+Del and I recovered it using easus data recovery software. But the excel file was not working. My file format was ms office 2007.

You may have 'recovered' the file, but not all the original contents... See post #2

maybe attach one or two of your corrupted files and we can try to recover it

It happens with almost everyone. By mistake, our important Excel file got deleted and we forgot to take backup. So, here is the method to recover deleted Excel file. In order to recover them use these 2 methods.

Method 1: Use MS Office Repair Option

It’s an inbuilt MS office Repair option. Follow these simple steps to recover the spreadsheets.

1. Open Excel and click on File>> Open.
2. Go to the folder where the damaged file is located and select it.
3. Select the arrow beside Open button and choose Open and Repair.
4. Choose Repair for the maximum data recovery.
5. If it fails, choose Extract Data option. Excel data should get retrieved.


Method 2: Recover Data from Temp Files

If you have the auto-recovery option enabled, you can get back the data from the temp files. By enabling this option it’s easy to recover damaged Excel file.

1. Go to the temp file location on your system:
On Windows 8/10:
C:\Users\\AppData\Local\Microsoft\Office\UnsavedFiles
On Windows 7:
C:\Users\name\AppData\Roaming\Microsoft\Excel\
2. Find out the temporary Excel file that ends with ‘.tmp’ and start with ‘$' or ‘~’.
3. Copy and paste the file to another folder and change the extension to XLSX.

I hope you find these solution reliable an deffective. I think you will your recover Excel files with the help of given methods.

Thankyou
Katherine Pearson

Hello, Everyone
First of all, You may need not worried so much about corrupted Excel file. It can be repaired easily you just need to perform some steps and that’s it your problem will vanish.
You can try the using open and Repair function, it is an inbuilt function in Excel that will repair corrupt Excel file. If not, this then Enable the Auto Backup and Auto Recover feature.
If none of this work to Repair Corrupt Excel File then you can take help of any third party Tool.
Good Luck with it!!!

I read in many forums that the recovered file got corrupted. To handle excel file corruption, try Open and Repair option.

1. Open MS Excel
2. Select the file which you want to repair
3. Select Open and Repair option
4. Click Repair

This is the basic repair option provided by Microsoft. If Repair option is not working then, there is another option called extract. You can extract the content if file is severely corrupted.

If you already tried it, then open Excel in Safe mode. If the file is opening without issue then, you can try to delete Com Add-ins. How to delete Com Add-in (Please Google it)

I will also suggest you read this: https://support.office.com/en-gb/article/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53

If you want to go with third-party tools then, I will suggest stellar Excel Repair software (as per my experience).

There are possible causes of Excel file corruption:

• If you’re using an unsupported Excel file format or
• The file may corrupt due to sudden power off.
• when opening an older version of the excel file in a new version on MS Office

Also, here are the solutions you can use to solve the error:

Solution 1: Change the default file format.

Try changing the Excel default file format by following these steps:

1. In Excel 2010 and newer versions, click on the File menu.
2. In the Info screen that appears, click on Options.
3. In the ‘Excel Options’ window, under the Save workbooks section, click on the Save files in this file format: drop-down. Select a file format (i.e., the one supported by your Excel version).
4. Click OK.

Check if you can open your Excel file. If not, try the next solution.

Solution 2: Edit the excel file permissions

Follow these steps to change the file permissions and see if it fixes the problem:

1. Right-click on the file that won’t open and click Properties.
2. In the file properties dialog box, click the Security tab and then hit the Edit button.
3. When the file’s permissions dialog box appears, click on the Add button.
4. Click on the Advanced button from the ‘Select Users or Groups’ window.
5. Select Find Now. A list of all users and groups will get displayed in a search results box. Choose Everyone group from the list and hit OK.
6. You can see the ‘Everyone’ group in the ‘Enter the object names to select’ textbox. Click OK once again to return to the file’s permission dialog box.
7. Click Everyone from the Group or user names: box and check all the checkboxes under Allow.
8. Click on Apply and then OK.

I hope this will help.

Best Regards,

Cheryl