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

Posted on 2009-07-08
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.
Question by:rleton
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2

Expert Comment

ID: 24808241

Please attach file,



Author Comment

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?

Author Comment

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.  

Accepted Solution

Robert7827 earned 500 total points
ID: 24809976

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


Expert Comment

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.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

756 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