Solution : Excel Report Error (DCS, SCADA)


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