Repair Excel File

Excel worksheets can get corrupt or damaged at anycell formulas.
point of time. Just imagine working on importantIf converting to WordPad, the data recovery would be
financial figures and power goes off. And when powerpossible in Visual Basic code in the modules and class
comes back, you cannot access your worksheet ormodules. Search for the "Sub" and "Function" word to
the excel file fails to open. Now what to do?find the code.
4. Open file in MS Excel Viewer
There are times when MS Office applicationYou can recover the lost data with the help of MS
automatically recovers the unexpected closedExcel Viewer. MS Excel Viewer is a small, freely
document with the help of Auto recover option anddistributed program which enables you to view and
your data is saved from being lost and inaccessible.print Excel for Windows (v2.0 and greater) and MS
But what happens when you cannot access yourExcel for Macintosh (v 2.2a and greater) spreadsheet
data, can you still get it back. The answer is "Yes".files.
Why not?Install the application and then you can copy the cells
The fast paced technology has developed suchand paste them in new worksheet. This method can
recovery tools to recover and restore the lost data. Ifonly recover the results of the formulas which are
you lose your data, you can still get it back bycurrently in the cell and the formatting of the file. Thus
performing some basic steps or at last if their remainsyou cannot recover macro sheets, module sheets,
no hope, you can select a third party utility - an exceldialog sheets, charts or VBA macro modules.
file repair software.5. Disable Macros
This article aims to discuss those methods and pointsDisable macros while attempting to open the corrupt
which prove helpful in the cases when you lose yourexcel file.
important data.6. Use of External Link Formulas in another Worksheet
How Data Becomes Corrupt or Inaccessible:Type the following command in the a1 cell of a new
Before discussing the preventions first we should lookworksheet: ='C:\My Documents\[Corrupt File
at some of the causes due to which the excel fileName.xls]Sheet'1!A1
gets corrupt. The causes are:Change the path according to the file location and
Virus Attackscorrupt file name. Copy this code down and over to
Unexpected or improper system shutdownmirror the range covered in the damaged file. Cell
Power Outagesvalues except the formulas or VBA codes can be
Media Errorsrecovered with this method.
Error messages like:7. Use of Excel's built-in Detect and Repair feature
"Excel unable to read file..",The "Detect and Repair" feature is the built-in recovery
"This file is not in a recognizable format",procedure through which data from the corrupt excel
"????.xls file cannot be accessed. The file may befiles can also be recovered. Follow the steps to use
read-only",this feature:
Excel.exe has generated errors and will be closed by
Windows. You will need to restart the program; an1. Open New Excel worksheet
error log is being created".2. Click the File menu and select the Open option.
Methods to Recover Data from the Corrupt Excel3. In the Open dialogue box, select the .xls file which
Files:you want to open. The Open button will get activated,
1. Saving the file in HTML formatclick the arrow and select the Open and Repair option.
2. Use of Revert To Saved Document feature4. Click the Repair button to start the process of
3. Open file in MS Wordrecovery and Extract Data button to extract data if
4. Open file in MS Excel Viewerexcel was unable to repair a previous workbook.
5. Disable MacrosThe Excel workbook with corruptions can be easily
6. Use of External Link Formulas in another Worksheetrecovered and repaired by using this method.
7. Use of Excel's built-in Detect and Repair feature8. Other Procedures
8. Other ProceduresAs the above mentioned steps can help you to
1. Saving the file in HTML formatrecover data from the corrupt excel files, you can also
If you are unable to access data or open thegive a try to these steps, which can prove helpful:
worksheet, then you can save the corrupt file in .html
format and then reopen it. To do this, perform the1. Close the Excel file and then re-open it.
following steps:2. This does not works, restart your computer system,
try to open the excel file again.
1. Click the File menu > click the Save As option.3. If this also not works, delete content from the
2. Click the Save as type list, select the Web Page"C:\Windows\Temp folder" and again restart the
(*.htm, *.html) option.Computer system.
3. Close the file4. If this also does not work then open the corrupt
4. Again open the file in MS Excelexcel file in Safe mode. This process disables the
5. Click the File menu, and select the Save As option.VBA and Add-ins. Click the Start menu and select the
6. Click the Save As type list and select the MicrosoftRun option.
Excel Workbook option. Change the name of the file,Enter the following command: "C:\Program
to create filtered copy without replacing the originalFiles\Microsoft Office\Office\excel.exe"/s. Now excel
worksheet file.in safe mode will start.
Note: Some features might get lost when the file isNote: If you are working on Excel 2002, Office XP, MS
saved in HTML format.Office Installer will start as you enter the command in
2. Use of Revert To Saved DocumentRun option. Click Cancel, safe mode will start.
While working on an excel worksheet, if by chance
your worksheet closes automatically or it becomes1. If this also does not work, scan the file for viruses.
corrupt before saving the changes then you can tryThis might solve the problem.
this method to retrieve the data back:2. You can also try this. Copy and paste the .xls file to
another partition and then try to open the file. This
1. Click the File menu and select the Open option.might actually work.
2. The Open dialogue box appears select the name of3. Finally when you have tried all the above-mentioned
the .xls file on which you were working.points and it seems that they will not work then you
3. As you select the .xls file, a dialogue box will becan select a third party utility to recover data from the
displayed with the following message : "Revert tocorrupt excel file. There are many excel file recovery
Saved Document"software which are designed to perform data
4. Click OKrecovery on the corrupt files.
The last saved version of the corrupt .xls file will beThe Excel File Repair software is an efficient corrupt
displayed.excel file recovery software which retrieves and
3. Open file in MS Word or WordPadrecovers data from the corrupt excel sheets. The
To open the MS Excel worksheet in MS Word, youexcel recovery software recovers the cell data,
need to install MS Excel converter on your computerformulas, charts, images, hyperlinks and other
system.embedded objects from the corrupt excel sheets.
If the corrupt excel file gets opened in MS Word thenYou can try the FREE demo version of the Kernel
you will be able to recover text and result of theExcel File Repair software and if the excel file data
formulas which are currently in the cells. You may notrecovery software displays your lost and inaccessible
be able to recover the dialog sheets, chart sheets,data then you can purchase Full version of the
embedded charts or any module sheets and also thesoftware.