Solved

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

Posted on 2009-07-08
5
2,012 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

774 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