Latest Posts »
Latest Comments »
Popular Posts »

Excel 2007 error: Different format than specified by the file extension

Written by Christian on March 17, 2008 – 9:48 am


In some cases after upgrading to Excel 2007, you may get the following error:
The file you are trying to open .xlsx is in a different format than specified by the file extension. verify the file is not corrupted and is from trusted source before opening the file. Do you want to open the file now?

This errors particularly occurs when you’re trying to open an XLS file (Excel 2000-2003) with Excel 2007. In most cases, the problem can be solved by defining MIME types and associating them with extensions.
When you’re using a Document Management System (like Sharepoint or Livelink), you can try adding these:
.xls = application/msexcel
.xlsx = application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

However, if you don’t want to look for a solution, but just want to solve the problem, insert this key in your registry to suppress the notification:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
“ExtensionHardening”=dword:00000000

You can accomplish the above by doing the following:

  1. Open your Registry (Start -> Run -> regedit.exe)
  2. Navigate to HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY
  3. Right click in the right window and choose New -> DWORD
  4. Type “ExtensionHardening” as the name (without the quotes)
  5. Verify that the data has the value “0″

People who read this article, also read:

Posted in Excel 2007 |

5 Comments to “Excel 2007 error: Different format than specified by the file extension”

  1. Amber Bhatnagar Says:

    Hi,

    Your solution really worked.Its excellent.

    Thanks,

    Amber Bhatnagar.

  2. Vasanth Says:

    Hi ,

    I have already tried the above solution , it’s working. But i want the solution in the way that from the jsp code. If you find any solution
    i will be very happy.

    Thanks,
    vasanth.

  3. Ted Says:

    Thanks a lot.

  4. Samita Says:

    Its working!!!!! wonderful….

  5. Rebecca Says:

    Thank you! As a non techie…your instructions were great! It took care of the problem.

Leave a Comment