[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 346
  • Last Modified:

MS Excel

is there a utility that fixes corrupted MS Excel documents?
i have a document that can't be opened.
i have had documents that excel 2003 couldn't open, be excel 2010 could, but for this document even 2010 has an error, i attached the screen shot.
 excel
0
JeffBeall
Asked:
JeffBeall
  • 8
  • 6
  • 5
  • +1
3 Solutions
 
leonstrykerCommented:
No, but I would recommend you do not use spaces, dashes, or other special characters in the file name. Using underscores '_' is fine.

Leon
0
 
redmondbCommented:
Hi, JeffBeall.

There are a number of approaches to recover corrupt spreadsheets. In my experience, corruption happens less with 2007/2010 than previous versions, but I have had success opening corrupt XLS'es using older versions Word. It's also possible to directly access the data using ADO/DAO.

What is the main thing you're looking for - the data, formatting, macros, or simply everything? (I've listed these in descending order of the likelihood of recovery.)

I presume it's out of the question for you to post the file here?

Thanks,
Brian.

0
 
JeffBeallAuthor Commented:
yes, i probably shouldn't post the actual file.
i think the data would be nice

"It's also possible to directly access the data using ADO/DAO"

i don't know what ADO/DAO is

so should i try to open this with word?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
redmondbCommented:
JeffBeall,

Yes, definitely try Word - worst that will happen is that crashes Word.

I've included an eclectic selection of ADO/DAO links (ADO being the more relevant) below, But unless it interests you, don't worry about them for the moment.
http://en.wikipedia.org/wiki/ActiveX_Data_Objects
http://www.ozgrid.com/forum/showthread.php?t=28221
http://stackoverflow.com/questions/1039224/is-it-better-to-use-ado-or-dao-in-access-2007
http://support.microsoft.com/kb/190195

Regards,
Brian.
0
 
leonstrykerCommented:
ADO will only work if you know the Sheet and Range names where the data resides. It is best with CSV type files, where data is arranged in a tabular matter.
0
 
JeffBeallAuthor Commented:
what is ADO?
0
 
redmondbCommented:
JeffBeall,

Please see my first link.

leonstryker,

Ranges are not an issue. Knowing the Sheet names is useful, but worst-case, they can be dug out.
0
 
leonstrykerCommented:
>Ranges are not an issue.

They will be an issue if the data on the sheet is not tabular, or there are multiple items.

>what is ADO?

ADO is data access object which allows you to access different types of data sources and query them using SQL. Most of the time it is used to connect to databases such as Access or SQL Server, or Oracle, but it can be also used to connect to Active directory or an Excel file.

Leon
0
 
redmondbCommented:
Leon,

They will be an issue if the data on the sheet is not tabular, or there are multiple items.
Not in a recovery situation! In the absolutely worst-possible case, you "just" pull A1:IV65536 - although I've never had to try that.

Regards,
Brian.
0
 
leonstrykerCommented:
>In the absolutely worst-possible case, you "just" pull A1:IV65536 - although I've never had to try that.

You can try, but in may cases ADO will get confused on the data type, where data changes from numbers to text, and reverse, and you may get NULLs instead of values. Its better if you know the range names, or address'

Basically, I would suggest you try this after everything else has failed.

Leon
0
 
byundtCommented:
I have occasionally run into files that were saved with the wrong extension. It is possible to do this using VBA and SaveAs method. The cure in such situations is to change the file extension and then see if the file opens.

For your particular situation, it is worth a try with .xlsx, .xlsm and .xlsb as the file extension. I'd make three copies of the original file and change the extension on each. You can then launch Excel 2010 and try to open them.
0
 
JeffBeallAuthor Commented:
so how would i use ADO to get the data?
i have a sql 2005 server.
i looked at those links about ADO and wasn't really following it.
0
 
leonstrykerCommented:
Like I said, try everything else first.
0
 
redmondbCommented:
JeffBeall,

As I said originally, "don't worry about them for the moment" - the Word option is a very quick and (if it works!) good option. Failing that, byundt's suggestion is worth trying.

Regards,
Brian.
0
 
redmondbCommented:
JeffBeall,

What am I saying?! If the problem is as byundt mentioned then his suggestion is the only sensible way to go. It doesn't do any harm so definitely try that first.

Regards,
Brian.
0
 
JeffBeallAuthor Commented:
so i attached what happened when i tried to open with word word
0
 
JeffBeallAuthor Commented:
hold everything.
i found one of those files that office creates when a file is closed improperly. i tried to open it with excel, and it is the file i'm having problems with!
so i guess we are all good.
0
 
redmondbCommented:
Excellent! DIY, eh?!
0
 
JeffBeallAuthor Commented:
thank you for the help.
0
 
redmondbCommented:
Thanks, JeffBeall.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 8
  • 6
  • 5
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now