?
Solved

Excel file corrupted.

Posted on 2016-09-29
13
Medium Priority
?
76 Views
Last Modified: 2016-10-06
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?
0
Comment
Question by:mikesmithccs
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 48

Expert Comment

by:Martin Liss
ID: 41822179
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.
0
 
LVL 48

Expert Comment

by:Martin Liss
ID: 41822200
Another idea. Do you have a checkpoint you can recover files from?
0
 
LVL 1

Author Comment

by:mikesmithccs
ID: 41822208
No, like I say this server doesnt have shadow copies enabled.
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 48

Expert Comment

by:Martin Liss
ID: 41822220
Did you try the ideas in post ID: 41822179?
0
 
LVL 1

Author Comment

by:mikesmithccs
ID: 41822238
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".
0
 
LVL 1

Author Comment

by:mikesmithccs
ID: 41822258
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."
0
 
LVL 1

Author Comment

by:mikesmithccs
ID: 41822265
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.
0
 
LVL 48

Expert Comment

by:Martin Liss
ID: 41822269
Can you attach the file?
0
 
LVL 1

Author Comment

by:mikesmithccs
ID: 41822272
Here you go.
Model-Box-Numbers.xls
0
 
LVL 48

Accepted Solution

by:
Martin Liss earned 2000 total points
ID: 41822293
It looks like it's empty to me and if so you're out of luck without a backup, but locate a hex editor and use it to verify the contents (if any) of the file.
0
 
LVL 1

Author Comment

by:mikesmithccs
ID: 41822295
I will give that a try. Thanks for all the help.
0
 
LVL 1

Author Closing Comment

by:mikesmithccs
ID: 41832523
File was damaged beyond recovery. I ended up using recovery software to find an old version and used it.
0
 
LVL 48

Expert Comment

by:Martin Liss
ID: 41832580
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
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question