Method 1 of 5: Repair Method 1. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-1.jpg> 1 *Open a blank Excel workbook.* 2. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-2.jpg> 2 *Go to Open.* 3. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-3.jpg> 3 *Find the desired file and choose Open and Repair.* This option is in the drop-down list associated with the *Open* button. - If Excel cannot open the file, choose *Extract Data*. 4. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-4.jpg> 4 *Confirm by clicking Yes.* If Excel warns you that the file caused a serious error the last time it was opened, agree to continue opening it. Edit<http://www.wikihow.com/index.php?title=Recover-a-Corrupt-Excel-File&action=edit§ion=1>Method 2 of 5: HTML Method 1. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-14.jpg> 1 *If you can, open the file.* 2. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-6.jpg> 2 *Go to Save As.* If necessary, choose *Other Formats* from the quick list of options. 3. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-7.jpg> 3 *Select Web Page from the possible file formats.* 4. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-8.jpg> 4 *Make sure Entire Workbook is selected and hit Save.* - Note that certain elements of the formatting may be lost. Click *Yes* to confirm or *Help* for more information. 5. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-9.jpg> 5 *Locate the saved file.* 6. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-10.jpg> 6 *Right-click the file and choose Open With > Microsoft Office Excel.* 7. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-11.jpg> 7 *Go to Save As and choose an Excel format from the drop-down list.* For example, *Microsoft Excel 97-2003* produces the classic *.xls* format, whereas *Excel Workbook* produces the newer *.xlsx* format. 8. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-12.jpg> 8 *Change the title to prevent confusing it with / saving over the (corrupted) original.* 9. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-13.jpg> 9 *Hit Save.* Edit<http://www.wikihow.com/index.php?title=Recover-a-Corrupt-Excel-File&action=edit§ion=1>Method 3 of 5: Copy Data Method 1. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-14.jpg> 1 *If you can, open the file.* 2. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-15.jpg> 2 *Right-click a sheet tab and choose Select All Sheets.* 3. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-16.jpg> 3 *Right-click a sheet tab and choose Move or Copy.* 4. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-17.jpg> 4 *Choose New Book and check the Create a Copy box.* 5. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-18.jpg> 5 *Hit OK.* Edit<http://www.wikihow.com/index.php?title=Recover-a-Corrupt-Excel-File&action=edit§ion=1>Method 4 of 5: XML Method (Excel 2003) 1. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-14.jpg> 1 *If you can, open the file.* 2. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-20.jpg> 2 *Go to Save As.* 3. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-21.jpg> 3 *Select XML Spreadsheet from the list of possible formats and hit Save.* 4. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-22.jpg> 4 *Close the file and reopen in Excel.* 5. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-23.jpg> 5 *Go to Save As.* 6. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-24.jpg> 6 *Select an excel format (ex. Microsoft Excel 97-2003 or Excel Workbook) from the drop-down list*. 7. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-25.jpg> 7 *Change the title to prevent saving over the (corrupted) original.* 8. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-26.jpg> 8 *Hit Save.* Edit<http://www.wikihow.com/index.php?title=Recover-a-Corrupt-Excel-File&action=edit§ion=1>Method 5 of 5: Other Possibilities 1. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-27.jpg> 1 *Close Excel, re-open it, and try to open the file again.* 2. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-28.jpg> 2 *If this doesn't work, restart the computer, open up Excel and try to open the file again.* 3. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-29.jpg> 3 *If this doesn't work, delete the contents of your c:\windows\temp directory then reboot.* Try again. 4. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-30.jpg> 4 *If this doesn't work, open the file using OpenOffice.* This is free, Microsoft-compatible software that may be able to work around the corruption. 5. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-31.jpg> 5 *If this doesn't work, open Excel in Safe Mode.* This will disable VBA and Add-ins. - Restart the computer in Safe Mode<http://www.wikihow.com/Start-Windows-in-Safe-Mode> . - Click on Start then Run then enter the actual path to the executable file. Depending on your version of Windows, this may be *C:\Program Files\Microsoft Office\Office\excel.exe*, *C:\Program Files (x86)\Microsoft Office\Office11\excel.exe*, or something similar. (For Excel 2002, Office XP, click cancel if the MS Office Installer starts; Excel in safe mode will still start)]. - Try to open the file. 6. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-32.jpg> 6 *If this doesn't work, be sure to scan the file for viruses.* Make sure your macro heuristics scanning option is turned on. Ask your IT administrator how to do this. 7. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-33.jpg> 7 *If you don't find a virus, copy the file and rename the copy with a .doc extension*. (This option may not be available on newer systems.) Try to open it as Word document. 8. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-34.jpg> 8 *If this doesn't work, try to determine if the file is unrecoverable on the disk.* Open the file in Explorer and try to copy it to another location. - If you can copy the file to another location, skip to step 9. If not, the actual sectors on the disk may be corrupted. - If the data is valuable enough to you, seek professional services as a damaged hard disk file recovery is not for the faint at heart. 9. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-35.jpg> 9 *If this doesn't work, try to open the file in a more recent version of Excel.* As the version numbers increase, their ability to recover corrupt files increases. If this doesn't work or such a version of Excel is not available, see if some other spreadsheet application is and try to open the file in that program. 10. <http://www.wikihow.com/Image:Recover-a-Corrupt-Excel-File-Step-36.jpg> 10 *If this doesn't work, copy the file and rename the copy with a .txt extension*. (This option may not be available on newer systems.) Try opening the file, and if Windows says it can't open it Notepad but will open it in WordPad, agree. Be sure to turn on word wrapping in either program; in Notepad it's under the Format menu, and in WordPad it's under the View menu (choose Options, choose the Text Tab, and choose Wrap to Window). Next, look for where the data stops, which should be followed by a bunch of spacer characters. These actually tell Excel where cells, columns, and rows are. When you find your last bit of data, delete the rest of the file. After this, rename it back to an .xls extension, try opening the file in the oldest version of a spreadsheet you can find. You may be able to recover your data in some semblance of a spreadsheet. On Tue, Nov 26, 2013 at 12:01 PM, Andrew Kerich <andykerich@gmail.com>wrote:

Hi Skunk(ette)s,

My client has a corrupt excel file showing 0kb file size. Is this recoverable? I have tried various data recovery utilities in vain. There is also no temp file. The file is located in a network share drive with no backup.

Any ideas?

Rgds, Kerich.

_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke

If you are familiar with HexEdit you can use it to fix the file Steve ----- Original Message ----- | From: "Andrew Kerich" <andykerich@gmail.com> | To: "Skunkworks forum" <skunkworks@lists.my.co.ke> | Sent: Martes, 26 de Noviembre 2013 9:01:36 | Subject: [Skunkworks] Data Recovery Excel | Hi Skunk(ette)s, | My client has a corrupt excel file showing 0kb file size. | Is this recoverable? I have tried various data recovery utilities in | vain. There is also no temp file. | The file is located in a network share drive with no backup. | Any ideas? | Rgds, | Kerich. | _______________________________________________ | skunkworks mailing list | skunkworks@lists.my.co.ke | ------------ | List info, subscribe/unsubscribe | http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks | ------------ | Skunkworks Rules | http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 | ------------ | Other services @ http://my.co.ke