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