How to Recover a Corrupt Excel File

View previous topic View next topic Go down

How to Recover a Corrupt Excel File

Post  THE GIVEAWAY BLOG!! on Wed Feb 12, 2014 7:56 am

Method 1 of 5: Repair Method
spaceplay / pause escstop ffullscreen shift + ←→slower / faster (latest Chrome and Safari)
↑↓volume mmute
←→seek . seek to previous 12…6 seek to 10%, 20%, …60%

1Open a blank Excel workbook.
Ad


spaceplay / pause escstop ffullscreen shift + ←→slower / faster (latest Chrome and Safari)
↑↓volume mmute
←→seek . seek to previous 12…6 seek to 10%, 20%, …60%

2Go to Open.
spaceplay / pause escstop ffullscreen shift + ←→slower / faster (latest Chrome and Safari)
↑↓volume mmute
←→seek . seek to previous 12…6 seek to 10%, 20%, …60%

3Find 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.
4Confirm 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.
Method 2 of 5: HTML Method
1If you can, open the file.
2Go to Save As. If necessary, choose Other Formats from the quick list of options.
3Select Web Page from the possible file formats.
4Make 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.

spaceplay / pause escstop ffullscreen shift + ←→slower / faster (latest Chrome and Safari)
↑↓volume mmute
←→seek . seek to previous 12…6 seek to 10%, 20%, …60%

5Locate the saved file.
spaceplay / pause escstop ffullscreen shift + ←→slower / faster (latest Chrome and Safari)
↑↓volume mmute
←→seek . seek to previous 12…6 seek to 10%, 20%, …60%

6Right-click the file and choose Open With > Microsoft Office Excel.
7Go 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.
spaceplay / pause escstop ffullscreen shift + ←→slower / faster (latest Chrome and Safari)
↑↓volume mmute
←→seek . seek to previous 12…6 seek to 10%, 20%, …60%

8Change the title to prevent confusing it with / saving over the (corrupted) original.
spaceplay / pause escstop ffullscreen shift + ←→slower / faster (latest Chrome and Safari)
↑↓volume mmute
←→seek . seek to previous 12…6 seek to 10%, 20%, …60%

9Hit Save.
Method 3 of 5: Copy Data Method
1If you can, open the file.
2Right-click a sheet tab and choose Select All Sheets.
3Right-click a sheet tab and choose Move or Copy.
4Choose New Book and check the Create a Copy box.
5Hit OK.
Method 4 of 5: XML Method (Excel 2003)
1If you can, open the file.

2Go to Save As.

3Select XML Spreadsheet from the list of possible formats and hit Save.

4Close the file and reopen in Excel.

5Go to Save As.

6Select an excel format (ex. Microsoft Excel 97-2003 or Excel Workbook) from the drop-down list.

7Change the title to prevent saving over the (corrupted) original.

8Hit Save.

Method 5 of 5: Other Possibilities
1Close Excel, re-open it, and try to open the file again.

2If this doesn't work, restart the computer, open up Excel and try to open the file again.

3If this doesn't work, delete the contents of your c:\windows\temp directory then reboot. Try again.

4If this doesn't work, open the file using OpenOffice. This is free, Microsoft-compatible software that may be able to work around the corruption.

5If this doesn't work, open Excel in Safe Mode. This will disable VBA and Add-ins.

Restart the computer 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.
6If 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.

7If 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.

8If 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.
9If 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.

10If 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.

Ad


Know another method for How to Recover a Corrupt Excel File? Add it here...
Add Method
Tips
If you know someone with a Mac, save the file to a thumb drive. View the contents of the thumb drive with Finder. You will be able to see the file extension .xlsx. Change the file extension to .xls. Open the file. Perform a Save As and save the file with the .xlsx extension.
You would be well advised to take a look at Microsoft's articles on the subject first even if you find them confusing. If you have Excel 2002 and 2003, use this guide; for newer versions, use this guide.
Ad


Warnings
This process can be time-consuming or expensive – or, in some rare cases, both.
avatar
THE GIVEAWAY BLOG!!
Admin

Posts : 161
Join date : 2012-06-11
Age : 28
Location : Malaysia

View user profile http://thousandgiveaway.blogspot.com

Back to top Go down

Re: How to Recover a Corrupt Excel File

Post  AbelBillingsley on Fri Sep 18, 2015 1:58 pm

Excel file recovery utility is very simple to use and any one can easily operate it without need of any professional knowledge. Simply download Excel file recovery tool and recover your corrupt excel file. Download this tool :- mannatsoftware.com/stellar-phoenix-excel-repair.html

AbelBillingsley

Posts : 31
Join date : 2015-09-18

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum