How to remove warning message that is appearing when we are trying to open an excel file generated by sqr or app engine..

To Avoid Warning Message like Incompatible Extension While Opening an Excel File

Some times people will get warning message like incompatible extension , when they are trying to open an excel file that is generated by sqr or application engine. To avoid this warning message, follow the below steps. User need to logged in as administrator or user should have admin rights to edit the Registry.

1. Navigate to the "HKEY_CURRENT_USER\Software\Microsoft\Office\[OfficeVersionNumber]\Excel\Security" key, where [OfficeVersionNumber] has to be matched with the version number of your installed MS Office.

[OfficeVersionNumber]
Office 2007 -> 12.0
Office 2010 -> 14.0

2. Insert a new DWORD value: (Right Click) 
- Value name: ExtensionHardening
- Value type: REG_DWORD
- Value data: 0

3. Navigate to the "HKEY_USERS\.DEFAULT\Software\Microsoft\Office\[OfficeVersionNumber]\Excel\Security" key, where [OfficeVersionNumber] has to be matched with the version number of your installed MS Office.

4. Insert a new DWORD value:  (Right Click) 
- Value name: ExtensionHardening
- Value type: REG_DWORD
- Value data: 0