Solved

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

Posted on 2009-07-08
5
1,965 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
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…

706 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

19 Experts available now in Live!

Get 1:1 Help Now