Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Problem opening excel sheet in 2010 office

colkas2012 (MIS) (OP)
29 Feb 12 12:58
Hi

I am new to the site.  We havr a problem after Office upgrade opening an .xls file in Office 2010. The message we get when trying to open it is;

name.xls cannnot be accessed.  the file may be corrupted or read only 2010

We have copied it locally, tried opening with repair, tried renamming it, the attributes are ok and not read only.

Does anyone have any ideas how to open this without having to purchase software to do this.  It is an important file so we dont want to lose it if possible.

Thanks

 
MazeWorX (IS/IT--Management)
1 Mar 12 5:54
Have you tried to import it into a new workbook and saving as 2010?

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

JockMullin (MIS)
1 Mar 12 10:12
I have had some luck opening corrupt .xls files in OpenOffice.

If you have a copy of the original .xls taken before "repair" attempts, it wouldn't take long to temporarily install OpenOffice or LibreOffice on a workstation, and open it in the calc module. Typically if there is a problem with the .xls file, calc will at least give you a partial worksheet, which you can then save in .xls format under another name.

Whatever calc saves as .xls should be OK in Office 2010.

May or may not work depending on the problem, but it is free.

Jock
colkas2012 (MIS) (OP)
1 Mar 12 10:42
Hi

Thanks for the replies.  I have tried both suggestions already, the import will not work because the file cannot be opened.  I tried opneoffice but kept getting a General Input/output errror.

I have also tried various other things from a google search.  I downloaded a free repair tool and this shows some data but of course you then have to pay for the repair which I dont want to do.  I have extensively searched this site  also.

So I think the file is totally coppupt.  Thanks anyhow.

 
hawkdaddy (TechnicalUser)
1 Mar 12 11:07
http://office.microsoft.com/en-us/excel-help/recover-earlier-versions-of-a-file-in-office-2010-HA010356735.aspx

Did you have autorecover enabled.  What was the previous version?
Do you auto back-up the My documents folder?

Hope this helps.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close