Senthil Murugan's Blog

Home » Apex » "The file you are trying to open … different format than specified by the file extension" while opening XLS (HTML saved as XLS)using Excel 2007, 2010 or 2013

"The file you are trying to open … different format than specified by the file extension" while opening XLS (HTML saved as XLS)using Excel 2007, 2010 or 2013

Dear Friends,

Due to various reason, software are saving HTML file as XLS and allowing users to open the file using excel software.

Users are getting the above error message, to avoid this error message, you can add the below entry in registry, so that this warning message will disappear while opening the file.

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

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

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

 

Thanks to IBM Support Team

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: