How to Repair Excel Files

  • by Neha Gupta
  • Published on 2/10/07
  • Article views: 761
Your Ad Here

Excel worksheets can get corrupt or damaged at any point of time. Just imagine working on important financial figures and power goes off. And when power comes back, you cannot access your worksheet or the excel file fails to open. Now what to do?

There are times when MS Office application automatically recovers the unexpected closed document with the help of 'Auto recover' option and your data is saved from being lost and inaccessible. But what happens when you cannot access your data, can you still get it back. The answer is 'Yes'. Why not?

The fast paced technology has developed such recovery tools to recover and restore the lost data. If you lose your data, you can still get it back by performing some basic steps or at last if their remains no hope, you can select a third party utility an excel file repair software.

This article aims to discuss those methods and points which prove helpful in the cases when you lose your important data.

How Data Becomes Corrupt or Inaccessible:

Before discussing the preventions first we should look at some of the causes due to which the excel file gets corrupt. The causes are:

  • Virus Attacks
  • Unexpected or improper system shutdown
  • Power Outages
  • Media Errors
  • Error messages like:
  • 'Excel unable to read file..',
  • 'This file is not in a recognizable format',
  • '????.xls file cannot be accessed. The file may be read-only',
  • Excel.exe has generated errors and will be closed by Windows. You will need to restart the program; an error log is being created'.

Methods to Recover Data from the Corrupt Excel Files:

  1. Saving the file in HTML format
  2. Use of Revert To Saved Document feature
  3. Open file in MS Word
  4. Open file in MS Excel Viewer
  5. Disable Macros
  6. Use of External Link Formulas in another Worksheet
  7. Use of Excels built-in Detect and Repair feature
  8. Other Procedures

1. Saving the file in HTML format

If you are unable to access data or open the worksheet, then you can save the corrupt file in .html format and then reopen it. To do this, perform the following steps:

  1. Click the File menu > click the Save As option.
  2. Click the Save as type list, select the Web Page (.htm, .html) option.
  3. Close the file
  4. Again open the file in MS Excel
  5. Click the File menu, and select the Save As option.
  6. Click the Save As type list and select the Microsoft Excel Workbook option. Change the name of the file, to create filtered copy without replacing the original worksheet file.

Note: Some features might get lost when the file is saved in HTML format.

2. Use of Revert To Saved Document

While working on an excel worksheet, if by chance your worksheet closes automatically or it becomes corrupt before saving the changes then you can try this method to retrieve the data back:

  1. Click the File menu and select the Open option.
  2. The Open dialogue box appears select the name of the .xls file on which you were working.
  3. As you select the .xls file, a dialogue box will be displayed with the following message : 'Revert to Saved Document'
  4. Click OK

The last saved version of the corrupt .xls file will be displayed.

3. Open file in MS Word or WordPad

To open the MS Excel worksheet in MS Word, you need to install MS Excel converter on your computer system.

If the corrupt excel file gets opened in MS Word then you will be able to recover text and result of the formulas which are currently in the cells. You may not be able to recover the dialog sheets, chart sheets, embedded charts or any module sheets and also the cell formulas.

If converting to WordPad, the data recovery would be possible in Visual Basic code in the modules and class modules. Search for the 'Sub' and 'Function' word to find the code.

4. Open file in MS Excel Viewer

You can recover the lost data with the help of MS Excel Viewer. MS Excel Viewer is a small, freely distributed program which enables you to view and print Excel for Windows (v2.0 and greater) and MS Excel for Macintosh (v 2.2a and greater) spreadsheet files.

Install the application and then you can copy the cells and paste them in new worksheet. This method can only recover the results of the formulas which are currently in the cell and the formatting of the file. Thus you cannot recover macro sheets, module sheets, dialog sheets, charts or VBA macro modules.

5. Disable Macros

Disable macros while attempting to open the corrupt excel file.

6. Use of External Link Formulas in another Worksheet

Type the following command in the a1 cell of a new worksheet: =C:My DocumentsCorrupt File Name.xlsSheet1!A1

Change the path according to the file location and corrupt file name. Copy this code down and over to mirror the range covered in the damaged file. Cell values except the formulas or VBA codes can be recovered with this method.

7. Use of Excels built-in Detect and Repair feature

The 'Detect and Repair' feature is the built-in recovery procedure through which data from the corrupt excel files can also be recovered. Follow the steps to use this feature:

  1. Open New Excel worksheet
  2. Click the File menu and select the Open option.
  3. In the Open dialogue box, select the .xls file which you want to open. The Open button will get activated, click the arrow and select the Open and Repair option.
  4. Click the Repair button to start the process of recovery and Extract Data button to extract data if excel was unable to repair a previous workbook.

The Excel workbook with corruptions can be easily recovered and repaired by using this method.

8. Other Procedures

As the above mentioned steps can help you to recover data from the corrupt excel files, you can also give a try to these steps, which can prove helpful:

  1. Close the Excel file and then re-open it.
  2. This does not works, restart your computer system, try to open the excel file again.
  3. If this also not works, delete content from the 'C:WindowsTemp folder' and again restart the Computer system.
  4. If this also does not work then open the corrupt excel file in Safe mode. This process disables the VBA and Add-ins. Click the Start menu and select the Run option. Enter the following command: 'C:Program FilesMicrosoft OfficeOfficeexcel.exe'/s. Now excel in safe mode will start.

Note: If you are working on Excel 2002, Office XP, MS Office Installer will start as you enter the command in Run option. Click Cancel, safe mode will start.

  1. If the above does not work, scan the file for viruses. This might solve the problem.
  2. You can also try this. Copy and paste the .xls file to another partition and then try to open the file. This might actually work.
  3. Finally when you have tried all the above-mentioned points and it seems that they will not work then you can select a third party utility to recover data from the corrupt excel file. There are many excel file recovery software which are designed to perform data recovery on the corrupt files.

The Excel File Repair software is an efficient corrupt excel file recovery software which retrieves and recovers data from the corrupt excel sheets. The excel recovery software recovers the cell data, formulas, charts, images, hyperlinks and other embedded objects from the corrupt excel sheets.

You can try the FREE demo version of the Kernel Excel File Repair software and if the excel file data recovery software displays your lost and inaccessible data then you can purchase Full version of the software.

Excel File Recovery Software supports data recovery from almost every version of MS Excel including MS Excel 2003, 2000, 97, XP.

Neha Gupta Nucleus Data Recovery http://www.kerneldatarecovery.com

Bookmark it: Digg this! Add to Del.icio.us Furl this! Add to Stumbleupon Add to Facebook

Rate this article:

More Articles

  • Are you annoyed of slow PC Startup & Shutdown?
    Startup manager is a utility that will optimize your PC startup so that your slow PC becomes fast. This utility is from PC Optimizer Pro which provides some other useful utilities also to supercharge your PC for maximum security and performance.
  • How Retail POS Software Can Improve Your Business
    If controlling and managing your retail business is driving you to the point of despair then you need to think about using a Point-of-sale (POS) software solution to help you regain control and ensure that you are steering your business in the right direction.
  • Cold fusion - The Salvage from the Energy Crisis
    The original reports of cold fusion in an electrolytic cell in 1989 were met with rejection and ridiculing by most mainstream scientists. Since that time cold fusion has been amply confirmed by replicated experiments, and the phenomenon is by now recognized as something real by steadily more scientists. However, in the popular daily media this scientific field seems to be treated as a taboo area to stay away from.
  • Why My Office Files Do Not Open?
    Have you ever wondered why is your office file not working or is not opening up with its respective program. This article aims to provide you with solutions when you are unable to open a file or access its data because of unknown reasons. Read on to know why all this happens and how can you correct this on your own.
  • How to Repair Excel Files
    How many times have you lost your excel worksheet data because of unknown reasons. Excel worksheets can get corrupt or damaged at any point of time. Just imagine working on important financial figures and power goes off. And when power comes back, you cannot access your worksheet or the excel file fails to open. Now what to do? Here I would discuss the causes of data corruption and ways to repair excel files.
  • How to Repair Excel Files
    How many times have you lost your excel worksheet data because of unknown reasons. Excel worksheets can get corrupt or damaged at any point of time. Just imagine working on important financial figures and power goes off. And when power comes back, you cannot access your worksheet or the excel file fails to open. Now what to do? Here I would discuss the causes of data corruption and ways to repair excel files.
  • Impressions of Testing Two Way Radio Midland GXT 550
    It's to time to tell about my testing of Midland GXT 550. This two-way radio differs from Midland GXT 500 only in camouflage coloring of enclosure. The enclosure is made of thick rough-service plastic. Once you take it, you feel its massiveness. It's no wonder, as it weighs 6.9ounce (196 gram) with battery and clip.
  • Why My Office Files Do Not Open?
    Have you ever wondered why is your office file not working or is not opening up with its respective program. This article aims to provide you with solutions when you are unable to open a file or access its data because of unknown reasons. Read on to know why all this happens and how can you correct this on your own.
  • Cold fusion - The Salvage from the Energy Crisis
    The original reports of cold fusion in an electrolytic cell in 1989 were met with rejection and ridiculing by most mainstream scientists. Since that time cold fusion has been amply confirmed by replicated experiments, and the phenomenon is by now recognized as something real by steadily more scientists. However, in the popular daily media this scientific field seems to be treated as a taboo area to stay away from.
  • Are you annoyed of slow PC Startup & Shutdown?
    Startup manager is a utility that will optimize your PC startup so that your slow PC becomes fast. This utility is from PC Optimizer Pro which provides some other useful utilities also to supercharge your PC for maximum security and performance.
  • How to Straighten Out Your Tax Affairs in 2010
    Utter the word 'taxes' in front of people and you are sure hear a loud groan. Frankly, there are valid reasons behind this response: First of all, paying your taxes annually can be a financial burden, especially with the economic hard times which we are going through these days.
  • Benefits of Yoga - Redefining Life, Meditation and Exercise
    Yoga is a complete exercise for the mind, body and soul and it can give a person a change to know himself in a new light. Regular practice of Yoga has been known to reduce stress, increase concentration and also benefit one's overall health.
  • The Best Floral Perfumes
    Floral perfumes are considered the best perfumes all over the world. In fact the history of perfumes says that floral perfumes are the first perfume category of the world and thus popular also. Floral perfumes represent the essence of love and romance.
  • Coffee Gift Baskets
    Even a Coffee Bean or San Francisco Coffee outlet frequenter will not be able to master the art of appreciating true gourmet coffee unless they know the history and information about gourmet coffee.
  • Rent a car in Israel
    If you are already in Israel and wish to rent a car, then you can make a booking and tell the service to pick you up from wherever you are. The best part about car rental in Israel is that they are extremely flexible.
  • A History of Vintage Automobiles - From 1916 to 1924
    Before cars were around, people usually traveled distances using horse-drawn carriages. But as early as 1335 several bright minds have been trying to come up with a 'horseless carriage'.
  • Ecommerce Checkout - Make Them Register
    The world of ecommerce is expanding daily as more and more retailers take their business to the web in the hopes of attracting a percentage of those ever finicky web shoppers. As the amount of businesses open up ecommerce shops online, the amount of web development companies is also growing, offering ecommerce solutions for even the smallest of budgets. It is important that web developers understand the dynamics of the checkout process when discussing the options with the client.
  • 3 Rules to Follow in Your Logo Design
    When designing your own logo or getting it done by logo design professionals, ensure the following three basic rules and you will have a great and memorable corporate identity.
  • Common mistakes before starting a website
    If you want your website to be a big hit then you need to avoid some common mistakes before starting one. Here you have a list of pitfalls that are designed for beginner and for many established ones too. Check out the common mistakes that have to be avoided for sure!
  • Top 10 SEO secrets
    Today everyone wants to have better search engine result pages ranks. However only one can have the rank 1. Therefore you need to optimize constantly your websites and to have an edge over others you need to do something different and unique. Following are 10 rare tips/secrets which can help you get high search engine ranks.


The opinions expressed in the above articles are solely of the authors and the owners of Point Articles may or may not agree with them. Copyright (c) 2010 Point Articles. All rights reserved.
Script error: local_46140.xml does not exist. Please create a blank file named local_46140.xml.