473,323 Members | 1,537 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Corrupt excel .XLSX file

1
Hey guys,
i have a couple of excel .XLSX files that i have been trying to open but i haven't had any luck with then excel says "excel cannot open filename.xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file"
May 8 '15 #1
4 7794
Luuk
1,047 Expert 1GB
And? What is your question regarding this?

Can you give more info on how these files got corrupted?

Do you have a backup?

What have you tried to solve the problem before posting here?
May 8 '15 #2
A corrupt excel spreadsheet can be repaired by using Open and Repair technique. It is a built-in repair function that opens a corrupt excel file forcefully.
*Open MS Excel > press Ctrl+O > locate corrupt excel spreadsheet and select it.
*Click on the arrow shown beside Open button > select Open and Repair.
It will take just a few seconds to be completed and selected file will be opened, if possible.
Aug 7 '16 #3
Hi,Ronars

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.


2. If method 1 fails, there are still several methods to recover your Excel file manually with Excel, including writing a small VBA macro

3. Third, there are also free tools from third-parties that can open and read Microsoft Excel files, for example,

3.1 OpenOffice . 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 . 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 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

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!
Aug 8 '16 #4
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/ex...001034656.aspx (for Excel 2003)
http://office.microsoft.com/en-us/ex...017.aspx?CTT=1 (for Excel 2007)
http://office.microsoft.com/en-us/ex...840.aspx?CTT=1 (for Excel 2010)
http://office.microsoft.com/en-us/ex...554.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.microsoft.com/en-us/ex...#_Toc337637262
Apr 10 '17 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Doogie | last post by:
Can anoyne tell me why this VBScript will create the file to Excel just fine, but the Excel file will not open up? I am saving it as a xlsx file instead of an xls one and I have the new version of...
0
by: user1980 | last post by:
hello.. i am developing a page in asp to open an .xlsx file and display its contents.. i have used this connection string sConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data...
0
by: Amit Kumar M | last post by:
Hi, I am using apache POI to read a xlsx file and upload the data in the database. I have to do this work in a scheduler(at scheduled time) running on Jboss. As scheduler is running on different...
0
by: Kumaraguru | last post by:
Hi I have load the xlsx file in blob using POI when i tried to download the xlsx file from blob the xlsx file got saved but its not openening. when i tried to open the file its giving following...
3
by: Ramkumar85 | last post by:
Hi All, I have received some other date value from the .xlsx file. Used the Spreadsheet::XLSX module to read the data from the file. Source file value : 19/07/1988 14:00:00 The actual data :...
2
by: Ramkumar85 | last post by:
Hi All, I received the some other foreign character while read the data from xlsx file. Source xlsx file data : ΠΣ15 ΑΡΧΗΓΟΣ ΠΣ ΚΟΚΚΙΝΑΚΗΣ ΑΛΚ Output for the data : Î*Σ15 ΑΡΧΗΓΟΣ Î*Σ...
0
by: djpaul | last post by:
Hello, I'm trying to load a xlsx file into an XmlDocument and want to read some values within that document. What I did: Extract the Xlsx file to a temporary folder and loaded the...
4
by: PeterRee | last post by:
I have a user who was working on an Excel 2007 file from a thumbdrive.. all of a suddem the file will not open and generates the following error: "Excel cannot open the file 'filename.xlsx'...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.