Link to home
Start Free TrialLog in
Avatar of mikesmithccs
mikesmithccsFlag for United States of America

asked on

Excel file corrupted.

Guys,

I have an excel file on a serer that has somehow become corrupted. The owner of the business quit doing backups and shadow copies is not turned on. I have tried running some excel program that fix corrupted files to no avail. Right now I am running getdata back to see if maybe I can recover a file from a couple days ago that isnt corrupted. Any other ideas?
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Two things you can try.

Save the file as as xlsb file, close and open the xlsb file.

Import the sheets and code from the damaged wb into a new workbook.
Another idea. Do you have a checkpoint you can recover files from?
Avatar of mikesmithccs

ASKER

No, like I say this server doesnt have shadow copies enabled.
Did you try the ideas in post ID: 41822179?
Im about to. Concerned it wont work. One of the programs I ran that was supposed to fix corruption said  something to the effect of the "value in workbook is all 0s".
That did not work. I am still getting the error "excel cannot open the file 'xxxxxx.xxx' because the file format or the extension is not valid. Verify the file has not been corrupted and that the file extensions match the format of the file."
I am also getting "the file you are trying to open "xxxxx.xxx" is in a different format than specified by the file extension. This file is an xls file.
Can you attach the file?
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I will give that a try. Thanks for all the help.
File was damaged beyond recovery. I ended up using recovery software to find an old version and used it.
I'm glad I was able to at least partially help.

If you expand the “Full Biography” section of my profile you'll find links to some articles I've written that may interest you.

Marty - Microsoft MVP 2009 to 2016
              Experts Exchange MVE 2015
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2015