When you try to open an Excel report which is generated by DCS or SCADA you may see the following popup every time.
“The file you are trying to open, , is in a different format than specified by the file extension”
This popup is generated by Excel not by DCS or SCADA.
This popup can be avoided by a registry edit.
Go to Registry Editor [ REGEDIT]
Navigate to “HKEY_CURRENT_USER\Software\Microsoft\Office[OfficeVersionNumber]\Excel\Security”
Office number version varies depends on the installed Microsoft Office version .
Office 2003 -> 11.0
Office 2007 -> 12.0
Office 2010 -> 14.0
Office 2013 -> 15.0
Insert a new DWORD value:
*Value name: ExtensionHardening
- Value type: REG_DWORD
*Value data: 0
This can be used for all Windows based DCS and SCADA