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 do I repair Excel Files?

excel

  • Please log in to reply

#1
NicolasHofmann

NicolasHofmann

    New Member

  • Member
  • Pip
  • 2 posts

Hello Experts:
My problem is as follow:
We're reinstall an Laptop With Windows 7, but the user does not back up a folder, This folder contained several important Excel files, we run "Easy recovery" this tool recover the most important files but the files are corrupt and are no possible open in Microsoft Excel.
Someone know some way o app to repair this files, are very important because those have information that don't have stored in other database, mail or files.


  • 1

Advertisements


#2
AkseliKivela

AkseliKivela

    New Member

  • Member
  • Pip
  • 1 posts
✓  Best Answer

You can try XLS Repair Kit http://www.xls.repair/  to repair your corrupt Excel files.

However, for your case, I think the problem may come with "Easy Recovery", although it recovers several files with .xls extension, it may just put some garbage data inside these files so actually these files do not contain any valid excel data. In that case, you cannot use any file recovery tools to recover the so-called .xls files.
Therefore, you can check the raw data of the files and see if they actually contain the excel data. If you are not sure. You can upload it so that I can analyze the files. I also hope that this resource will be able to help you. May be you find useful information there. https://social.technet.microsoft.com/Forums/en-US/3160c5bd-457b-450a-92ab-2a99631acf0b/how-to-repair-file-me?forum=excel


  • 1

#3
NicolasHofmann

NicolasHofmann

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts

I am very glad that you helped me!)


  • 0

#4
felton1985

felton1985

    New Member

  • Member
  • Pip
  • 1 posts

For your case, 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:

http://office.micros...A001034656.aspx(for Excel 2003)
http://office.micros...7017.aspx?CTT=1(for Excel 2007)
http://office.micros...2840.aspx?CTT=1(for Excel 2010)
http://office.micros...9554.aspx?CTT=1(for Excel 2013)

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

http://office.micros...1#_Toc337637262

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.

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

https://www.datanume...m/excel-repair/

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!

 

Hello Experts:
My problem is as follow:
We're reinstall an Laptop With Windows 7, but the user does not back up a folder, This folder contained several important Excel files, we run "Easy recovery" this tool recover the most important files but the files are corrupt and are no possible open in Microsoft Excel.
Someone know some way o app to repair this files, are very important because those have information that don't have stored in other database, mail or files.


  • 0

#5
martinleo547

martinleo547

    New Member

  • Member
  • Pip
  • 2 posts

I think that inbuilt utility that comes with MS excel which is known as “Open & Repair” is the first step that you must go for repairing your excel file. Second option – If you have backup of the excel file then you can restore your excel file from there. But if both of the solution does not work then you can opt for software.  


  • 0

#6
kylfederer12345

kylfederer12345

    New Member

  • Member
  • Pip
  • 2 posts

In order to repair the corrupted Excel file, then, in that case, you have to follow the steps mentioned below.

1.       Click File > Open.

2.       Click the location and folder that contains the corrupted excel file.

3.       In the Open dialog box, select the corrupted excel file.

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

5.       In order to recover the data from MS excel as much as possible, click on repair.

If by using the above-mentioned ways you are unable to repair the excel file. Then, in that case, it can be repaired by using MS Excel Repair Tool. Using this software, you can easily recover them. Moreover using this software is very easy.


Edited by kylfederer12345, 03 December 2015 - 11:31 PM.

  • 0

#7
SaNaCa

SaNaCa

    New Member

  • Member
  • Pip
  • 1 posts

Someone know some way o app to repair this files, are very important because those have information that don't have stored in other database, mail or files.

Well I don't know any such app or utility to repair Excel file, but I can help you repair Excel file manually. There's no need to use any such paid software. The manual tricks don't require any paid software. You just need to use Microsoft Excel program, that's it. I can share this blog post here: Few Easy Tips & Tricks to Repair Excel File Manually | N. Sem's Blog

 

There are three different manual tricks which can be used to repair Excel file. First you can try Open and Repair trick, a built-in repair function available in Microsoft Excel. Data extraction is another thing you can try to repair Excel file. It also uses Microsoft Excel program. There's one more thing you can try here. You can convert your corrupt Excel file into SYLK or symbolic link format to recover data from it. 

 

I hope the shared information would be helpful. 

 

Thanks and best regards.


  • 0






Similar Topics


Also tagged with one or more of these keywords: excel

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