Solved

Cannot open html file with .xls file extension in Excel 2007

Posted on 2009-07-08
5
1,987 Views
Last Modified: 2012-05-07
When opening a file (with .xls file extension) in my web browser (IE6), it delivers an error "because the file format or file extension is not valid" msg.  When the file is saved, it can be opened in Excel '03, but not Excel '07.  I need for clients to be able to view in Excel '07.  What is causing this error, and how can it be fixed? NOTE: Changing the filename to .xlsx does not help.  File attached.
0
Comment
Question by:rleton
  • 2
  • 2
5 Comments
 
LVL 2

Expert Comment

by:Robert7827
ID: 24808241
rleton,

Please attach file,

Thanks,

Robert
0
 

Author Comment

by:rleton
ID: 24809427
Thought I did it.  I cannot upload the xls file in question because part of the problem is it isn't even being recognized as a .xls file (evern though Excel 2003 can open it).  When I try to upload the file to this site (from my computer which has Excel 2007) it fails giving the error...The extension of one or more files in the archive is not in the list of allowed extensions: [Content_Types].xml

Again the hyperlink to the file online (sorry but authentication required/password protected) so I can't put the link up.

Does this problem shed any clues as to what the problem might be?
0
 

Author Comment

by:rleton
ID: 24809431
Again the hyperlink to the file online (sorry but authentication required/password protected so I can't put the link up) opens with Excel 2003.  
0
 
LVL 2

Accepted Solution

by:
Robert7827 earned 500 total points
ID: 24809976
rleton,

Review the article at the below link to see what error number you get, then please let me know

http://support.microsoft.com/kb/928979

Robert
0
 

Expert Comment

by:quekyong
ID: 25139338
Hi, I encounter similar problem, a message "The file you are trying to open, "<Filename>", is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you wan to open the file now?"

The error number is 101786.

After clicking YES, the file can be opened though. But would like to know how to by-pass this message.
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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
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…

863 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

21 Experts available now in Live!

Get 1:1 Help Now