Topic: Excel data lost for work.

[MarkusHakala]

I have several old excel files that got corrupted when a server had a power surge. They were being used on a Mac 10.6 client and I have tried to fix with disk utility, many excel file repair packages on mac and pc and online, tried also opening in alternate software like open office and JMP to no avail. Is there any hope for this data?

[Samker]

Hi Markus,

For brief help, We need to know, which Excel version you use ??

Also, kindly checks:

... one older SCforum's topic with "similar" problem: http://scforum.info/index.php/topic,10143.0.html

... and instructions from official pages: https://support.office.microsoft.com/en-gb/article/Repairing-a-corrupted-workbook-7abfc44d-e9bf-4896-8899-bd10ef4d61ab?CorrelationId=b068cedc-7840-4c2c-9210-77504489d482&ui=en-US&rs=en-GB&ad=GB

cya later,

S.

[devnullius]

Sounds like you are out of luck... Especially after the disk check & repair tools, you should be able to access everything you see. If not, they are damaged. If the repair tools for office can't handle them, it looks like it's over

When it comes to corrupt Mac file systems, to my surprise there are a few tools that should help (http://www.techrepublic.com/article/3-data-recovery-applications-for-os-x/ - untested). Normally, on Unix filesystems, when you remove a file, it's gone. At least, I've always been told ;p

Sorry for the bad news, if you do manage to crack it, do let us know how

Devnullius

[justesen]

When an Excel file is corrupted, then you can try several methods to recover it:
1. First of all, you can try to repair the file manually in Excel, as follows:
(1) On the File menu, click Open.
(2) In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
(3) Click Open and Repair, and then choose which method you want to use to recover your workbook.
You may find more information about this at:
http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010097017.aspx?CTT=1 (for Excel 2007)
http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010342840.aspx?CTT=1 (for Excel 2010)
http://office.microsoft.com/en-us/excel-help/repair-a-corrupted-workbook-HA102749554.aspx?CTT=1 (for Excel 2013)

[justesen]

2. If method 1 fails, there are still several methods to recover your Excel file manually with Excel, including writing a small VBA macro, as below
http://office.microsoft.com/en-us/excel-help/repair-a-corrupted-workbook-HA102749554.aspx?CTT=1#_Toc337637262
3.For xlsx files, they are actually a group of files compressed in Zip file format. Therefore, sometimes, if the corruption is only caused by the Zip file, then you can use Zip repair tools to repair the file, as follows:
4.1 Assuming the corrupt Excel file is a.xlsx, then you need to rename it to a.zip
4.2 Start WinRAR, go to "Tools > Repair Archive" to repair a.zip and generated a fixed file a_fixed.zip.
4.3 Rename a_fixed.zip back to a_fixed.xlsx
4.4 Using Excel to open a_fixed.xlsx.
5. If all above methods do not work, then you may try third-party tools such as Excel Recovery Toolbox at http://www.oemailrecovery.com/excel_recovery.html
   It provides a free download version so that you can try to see if the data you want can be recovered or not. Good luck!

[justesen]

May be this link will help you? https://social.technet.microsoft.com/Forums/office/en-US/cac22d27-34d6-4d38-9183-18fbb0a062df/how-to-repair-corrupt-ms-excel-2003-xls-file?forum=excel

[MarkusHakala]

Thank you all for your advice! The issue has been resolved.

[edwards142]

You can recover your lost/corrupted Excel file data with some manual fixes. To grab knowledge about the manual fixes which you can try to recover corrupted Excel file.

Here are the fixes which you can try:

1: Use Open and Repair Tool
2: Restore corrupted Excel file from TMP file
3: Restore From File Recovery
4: Revert Workbook to last Saved Version
5: Disable Automatic Calculation

There are many more fixes like this….so just go through it and try them.
source: how to recover corrupted Excel file