Excel warning "File different format as extension"

[Koen Piller]

Hi,

When trying to open an Excel file I get this warning:
"The file you are trying to open is in different format as specified by the extension. Do you want to open?" Yes/No/Help

I click yes and file opens without any problem.
Extension is .xls
What is the format for a Excel2007 or -2010 xls file?

Regards,

Jockey(2)

 

[RTag]

The extension for 2007/2010 is xlsx. If you rename xlsx file to xls you will receive message like that.

http://www.R-Tag.com

Viewer, scheduler and manager for Crystal reports.
Send you report everywhere.

 

[Koen Piller]

Hi RTag,

When I do that I will get an error message informing (translated)

"The file myFile.XLSX cannot be opened due to the format of the the fileextension is not valid. Check if the file is not currupted and if the extension is according to the format."

with an OK button and no way to open the file.

Regards,

Jockey(2)

 

[Koen Piller]

Hi Sftw

I will test and report back if all my tests are negative. May take an other day.

Jockey(2)

 

[GlennUK]

You'll also get that message if you've saved a .txt file as .xls by the way. Can you open the file in Notepad?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Koen Piller]

Hi Glenn,
I am coming closer to the solution. The file is an XML file with following heading:

<?xml version="1.0" encoding="ISO-8859-1"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-comffice:spreadsheet"
xmlns="urn:schemas-microsoft-comfficeffice"
xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:html="

http://www.w3.org/TR/REC-html40">

I am still under investigation, thanks
Jockey(2)

 

[GlennUK]

OK, that's progress. Note that xlsm is also a valid filetype in Excel 2007 and Excel 2010.

Cheers, Glenn.

Beauty is in the eye of the beerholder.