Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

How to repair xls files

xls repair xls file repair xls file repair tool

  • Please log in to reply

#1
robert79

robert79

    New Member

  • Member
  • Pip
  • 1 posts
I have a xls file which I can open in excel 2003 but when i try to open it in excel 2007. The message below appears "Excel found unreadable content in work.xls. Do you want to recover the contents of this workbook? If you trust the source of this workbookm, click yes."
 
After I clicked yes...the content displayed is unreadable. Below is the log file.
 
Microsoft Office Excel File Repair Log
Errors were detected in file 'E:\work.xls'
The following is a list of repairs:
Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.
 
How do I solve this problem.

  • 0

Advertisements


#2
Dashing star

Dashing star

    Member

  • Member
  • PipPipPip
  • 722 posts

Hello robert79,

 

:welcome:

 

When Microsoft Excel detects a corrupted workbook upon opening, it automatically starts File Recovery mode and attempts to repair the workbook. If File Recovery mode doesn’t start, try using this manual process to recover your workbook:

 

Click File > Open.

 

Click the location and folder that contains the corrupted workbook.

 

In the Open dialog box, select the corrupted workbook.

 

Click the arrow next to the Open button, and then click Open and Repair.

 

308a7773-9c32-4a26-a632-7ef5b3df2b07.png

 

 

 

To recover as much of the workbook data as possible, pick Repair.

 

If Repair isn’t able to recover your data, pick Extract Data to extract values and formulas from the workbook.

 

If neither automatic nor manual repair works, there are some recovery methods that might help salvage your data. You can also take some preventive measures to avoid losing your work by automatically saving a backup copy of your workbook or creating a recovery file from time to time.

 

For more go here--> Repair Excel


Edited by Dashing star, 30 June 2015 - 05:58 AM.

  • 0

#3
Dashing star

Dashing star

    Member

  • Member
  • PipPipPip
  • 722 posts

Its been a long time you did not update your post...

 

You still need assistance? :mellow:

 

Regards


  • 0

#4
martinleo547

martinleo547

    New Member

  • Member
  • Pip
  • 2 posts

Follow the below steps to repair Excel file:

 

1.      Click the Microsoft Office Button, and then click Open.
2.      Select the corrupted excel sheet that you want to open.
3.      Click the arrow next to the Open button, and then click Open and Repair.
4.      Do one of the following:
  • Click Repair in order to recover as much of the workbook data as possible,
  • Click Extract Data in order to extract values and formulas from the workbook when an attempt to repair the workbook is not successful.
If you are not able to repair and recover your Excel sheet by using Open & Repair inbuilt utility then use MS Excel Repair and Recovery tool. But before that read this - Recover damaged xls and xlsx file   

  • 0

#5
trampadoo

trampadoo

    New Member

  • Member
  • Pip
  • 1 posts
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:
 
 
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
 
 
3. Third, there are also free tools from third-parties that can open and read Microsoft Excel files, for example,
 
3.1 OpenOffice at http://www.openoffice.org. This is a very famous open source project that is designed to support Office file formats, including Excel files. The software can run under Windows.
 
3.2 KingSoft Spreadsheets at http://www.kingsofts...fice/free-excel. This is a free Windows tool that can open Excel files. 
 
Sometimes when Excel fails to open your file, these tools may be able to open it successfully. If that is the case, then after the Excel file is opened, you can just save it as a new file which will be error-free.
 
4. 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 such as WinRAR at http://www.rarlab.comto 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. 
 
 
There may still be some warnings when opening the fixed file in Excel, just let ignore it and Excel will try to open and repair the fixed file. If the file can be opened successfully, then you can just save the contents into another error-free file.
 
5. If all above methods do not work, then you may try third-party tools such as DataNumen Excel Repair at
 
 
It provides a free demo version so that you can try to see if the data you want can be recovered or not.
 
Good luck!

  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP