Solution : Excel Report Error (DCS, SCADA)


#1

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