none
Excel 2013 ExtensionHardening RRS feed

  • Question

  • In Excel 2013 when exporting data to Excel from Microsoft Dynamics CRM I get the error:

    "The file format and extension of "FILENAME.xls" don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open the file"

    I got the same error when I had Excel 2010 but was able to find a registry key workaround that make the error go away. Now that I've upgraded to 2013 the error is back. The same registry keys don't look like they exist for 2013 and I've not been able to find anything online for a fix. Any advice?

    Here is the fix for Office 2010:

    Key: HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security
    Value: (DWORD)"ExtensionHardening" = [0 = Disable check; 1 = Enable check and prompt; 2 = Enable check, no prompt deny open]
    Default setting if value not present is 1 (enable and prompt).

    Wednesday, January 16, 2013 6:56 PM

All replies

  • Hi,

    I just tested in Excel 2013, and the same registry key works, though it isn't there by default. You may not remember this, but you had to create it for earlier versions as well. just create it:

    1. Go to HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\Security

    2. Edit --> New --> DWord value

    3. Name it ExtensionHardening. It will be on 0 by default.

    The file has to have an XLS extension, the key won't work for XLSX and the file wouldn't open using it.

    Hope this helps,
    Anita

    Tuesday, February 26, 2013 4:56 PM
  • Thanks for the information!  I had the same issue, and within 2 seconds, it was fix.  Very helpful and competent guidelines
    Wednesday, June 26, 2013 9:55 AM
  • I must log in to vote for your answer. It's really useful. Many thanks, bro. xD
    • Edited by Viet Fr Saturday, December 13, 2014 2:46 AM
    Saturday, December 13, 2014 2:46 AM