Solved

Cannot open excel xls files in excel 2010

Posted on 2011-02-23
10
1,957 Views
Last Modified: 2012-05-11
My user were on office 2000. We deployed office 2010 and now we are having issues with Excel 2010 that cannot open older 2000 exel files. Getting the following errors

"Excel cannot open the file because the file format or file extention is not valid. Verify that the file has not been corrupted and that the file extention matches the format of the file" for this message the file does not open at all.
or
"Excel found unreadable content in filname.xls. Do you want to recover the contents from this workbook? If you trust the source of the workbook, click yes." Doing so open the file in protected view but the contents are all messed up and useless.

If i try opening this file in windows 2000  or open office it opens fine. Tried opening it a couple windows XP and windows 7 machine and all are getting the above error.
0
Comment
Question by:LealIT
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 34960216
Do all Excel 2000 files could not be opened in 2010?

If there are only some files, then they might have macros on the file. There are VBA codes incompatibility with 2000 and the latest version.

Sincerely,
Ed
0
 
LVL 8

Expert Comment

by:Toxacon
ID: 34960239
0
 

Author Comment

by:LealIT
ID: 34960505
To MINDSUPERB:

Not not all windows 2000 files have this problem.
0
 
LVL 1

Accepted Solution

by:
ncit9933 earned 250 total points
ID: 34960507
Try download openoffice if all else fails, you can open with it and save as a version of Office
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 34960563
LealIT,

<Not not all windows 2000 files have this problem. >

There's a difference between windows 2000 and Excel 2000 or Office 2000.

If  you mean Excel 2000, then I suspect that the said file that you couldn't open in Excel 2010 might have macro on it.

Ed
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:LealIT
ID: 34967451
to MINDSUPERB:

Yes i meant excell 2000 . is there a way to work around the incompatible macro enabled files. installing open office and saving all the older files to a version of office that is compatible will be tioo much work.
0
 
LVL 8

Expert Comment

by:Toxacon
ID: 34970829
I'm not sure if OpenOffice supports automation but you could try the following:

1. Install the compatibility pack I mentioned earlier to computer with Excel 2000
2. Create a simple Office Automation vbscript that opens workbooks one by one and then saves them in 2007/2010 format. If they have macros, save in macro-enabled format. All macros may not be compatible, so they can't be converted without manual job.
0
 

Author Comment

by:LealIT
ID: 34979523
To Toxacon:
 
The PC the compabibility pack 2007 already installed.Tried opening it with the compatibility pack and it did not work. i then uninstalled and reinstalled the latest compabibility pack and tried again with no luck.
0
 
LVL 8

Assisted Solution

by:Toxacon
Toxacon earned 250 total points
ID: 34986165
If the Workbooks are vital to your business, you have the following options to proceed:

1. Manually convert the macros to Excel 2010 compatible format.
2. Set up virtual workstations to run Excel 2000 for calculations you need.
3. Use technologies like Remote Desktop Services or Citrix to run Excel 2000 while workstations have Excel 2010.

The options 2 and 3 give you more time to gradually move to Excel 2010 compatible workbooks, if necessary.
0
 

Author Comment

by:LealIT
ID: 35186784
These excel files were reports that are generated by a software, so we ask the developper to have the files generated in xlsx format and that resolved our issues.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

919 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now