Go Back   Computer Forums > General Computing > Software and Operating Systems
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 05-16-2016, 11:01 AM   #1
Beta Member
 
Join Date: May 2016
Location: OSA
Posts: 2
Default Repair of Excel file

Hi - I have a corrupted Excel file which I can't repair. I wonder would any of you be able to repair it? When you open the file writes that "cannot open the file because the file format or the file extension is invalid. Make sure the file is not corrupted and the file name extension matches the format". It's Excel 2010 . Thanks. (Cannot attach the file writes that "The file type you are attempting to upload is not allowed.")
__________________

JohnsGreens is offline   Reply With Quote
Old 05-16-2016, 09:58 PM   #2
Beta Member
 
Join Date: May 2016
Location: s
Posts: 1
Default Re: Repair of Excel file

Hi,JohnsGreens,

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:

http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010342840.aspx?CTT=1 (for Excel 2010)

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.microsoft.com/en-us/ex...#_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 Apache OpenOffice - Official Site - The Free and Open Productivity Suite. 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 Free Excel Alternative software download - highly compatible with 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 WinRAR archiver, a powerful tool to process RAR and ZIP files to 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.datanumen.com/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!
__________________

Lydia584 is offline   Reply With Quote
Old 05-23-2016, 11:51 AM   #3
Beta Member
 
Join Date: May 2016
Location: USA
Posts: 2
Default Re: Repair of Excel file

That file is beyond repair. I changed the extension to .XLS and forced it to open up and there is just gibberish inside of it. Do you have a backup or older version you can go back to? Maybe you should try to use the utility Excel Recovery Toolbox? may be it will help to restore at least some of the information. http://www.oemailrecovery.com/excel_recovery.html
RafallSosnowski is offline   Reply With Quote
Old 05-23-2016, 11:54 AM   #4
Beta Member
 
Join Date: May 2016
Location: USA
Posts: 2
Default Re: Repair of Excel file

Look also this source for more information
https://community.office365.com/en-us/f/172/t/256362
RafallSosnowski is offline   Reply With Quote
Old 05-27-2016, 10:05 AM   #5
Beta Member
 
Join Date: May 2016
Location: OSA
Posts: 2
Default Re: Repair of Excel file

Thank you guys for your feedback and help. Sorry, that long time did not respond. This is because the issue was solved and I forgot to tell.) Thank you!
JohnsGreens is offline   Reply With Quote
Old 05-27-2016, 11:46 AM   #6
Fully Optimized
 
crazyman143's Avatar
 
Join Date: May 2004
Location: USA
Posts: 2,946
Default Re: Repair of Excel file

How did you end up getting it repaired?
__________________

crazyman143 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 11:31 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0