MS Excel file is corrupt

Hello Experts,

Thanks in advance!

This is the second time when I am facing the Excel file corruption. First time, open and repair option helped me handle the corrupt excel file but, this time it is not working..

I read this article: https://goo.gl/1vnHtG from Microsoft and tried the repairing methods. The problem is still there. Please help me to fix this issue..
Excel file corruption message
Robin ShanabAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongCommented:
what if try rename the file from .xls to .xlsx and try open?
0
Robin ShanabAuthor Commented:
Thanks for your reply

I changed the file extension but, getting the same error message

excel error
0
Bharat BhushanSolution ManagerCommented:
Hello Robin,

If the file consists Macros, then the extension will be XLSM.. please try with XLSM extension
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Ryan ChongCommented:
how this file was being generated? is it via programming or was created via Excel program?

if it's former, then just open it and then do a save as.
0
Sandeep KumarAssociate ConsultantCommented:
It is simply corrupted. You need to repair it either by manual method or by using third party tools.

To repair Excel file refers to https://www.nucleustechnologies.com/blog/five-easy-ways-to-repair-excel-files-and-recover-lost-data/ to know the steps for repairing XLS or XLSX files manually.

Or go to https://www.nucleustechnologies.com/repair-excel-file.php to download Kernel for Excel Repair tool; an automated tool to repair Excel file. It supports upto latest Excel 2016 and Windows 10 OS.
0
Robin ShanabAuthor Commented:
@ryan, I generated this by Excel program. @robin, I tried this but, not worked..
0
Ryan ChongCommented:
I generated this by Excel program
via VBA codes i guess? make sure you saved the file with proper format and file extension.

post your SaveAs code here if necessary so we can verify the issue
0
Bharat BhushanSolution ManagerCommented:
Hello Robin,

I think the file got corrupted. To repair the corrupt excel file, you should try third party Excel Repair software.

Stellar Phoenix Excel Repair Software comes up with the demo version and shows the preview of corrupt Excel file. The software supports MS Excel 2016 and lower versions and compatible with Windows 10 and lower OS.

Try this and share the output here.

Good Luck!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Robin ShanabAuthor Commented:
@Ryan, Thank you for the suggestion.. The file was working perfectly last night so, there is no extension related issue. @Bharat and @Sandeep, I will try both software and share the result..
0
alanccwCommented:
Hi,Robin

The Excel xls file is stored as OLE2 storage format, a very complex file format. It starts with a file header containing the meta information of the whole file, followed by several parts containing the actual data. You can find more detailed information about the Excel xls file format by searching on Google with the keyword “Excel xls file format”. If the file header containing the meta information is corrupt, or any follow-up parts are damaged or corrupted, then you will not be able to open the file correctly with Excel. In such a case, the first step is to try to use the built-in repair or recovery function in the Excel, to see if it can repair or recover the corrupt file. If not, then you need to resort to a third-party xls recovery software to scan the corrupted file and recover Excel data for you. It is also possible to find a data recovery expert or company to do the task, but in most of the cases, they will also use a third-party tool to do the recovery for you.

The main difference between using the software by yourself and by a third-party service company is:
(1)      The company is familiar with the data recovery industry so he knows which software is the best one. While you need to search and compare the software online by yourself, which is time-consuming.
(2)      The company purchases the software for multiple usages, while you purchase the software for one-time usage only. So normally the service fee may be cheaper than the license fee for the software.
(3)      DIY will keep your data confidential while do the recovery via a company may cause data breach.

If you want to perform a DIY recovery, then you can try the following methods:

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-corrupted-files-in-excel-HA001034656.aspx (for Excel 2003)
http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010097017.aspx?CTT=1 (for Excel 2007)
http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010342840.aspx?CTT=1 (for Excel 2010)
http://office.microsoft.com/en-us/excel-help/repair-a-corrupted-workbook-HA102749554.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/excel-help/repair-a-corrupted-workbook-HA102749554.aspx?CTT=1#_Toc337637262


3. If all above methods do not work, then you can try DataNumen Excel Repair at:

https://www.datanumen.com/excel-repair/

I have used the tool in the past and it helps recovering some valuable data for me. The tool has a free demo so that you can try to see if it works on your file or not before you buy.

Hope this will help. Good Luck!
0
Robin ShanabAuthor Commented:
Kudos!!!
@Bharat, I fixed the issue with Stellar Excel repair..
repair file
Thanks to all experts for amazing help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.