Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2009-07-08
5
Medium Priority
?
2,147 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 2000 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

963 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