Excel Connector Problem with Office 2010

(imported topic written by SystemAdmin)

I installed the BigFix Excel Connector 3.3.2 on my Windows 7 64-bit with Office (Excel) 2010 installed.

When I open Excel. I get the following error message:

Detailed technical information follows:


(Inner Exception)

Date and Time: 06.02.2013 15:03:05

Machine Name: xxx

IP Address: xxx

Current User: xxx

Application Domain: D:\Users\xxx\AppData\Roaming\BigFix Enterprise\Tivoli Endpoint Manager Excel Connector 3.3\

Assembly Codebase: file:///D:/Users/xxx/AppData/Roaming/BigFix Enterprise/Tivoli Endpoint Manager Excel Connector 3.3/AddinExpress.MSO.2005.DLL

Assembly Full Name: AddinExpress.MSO.2005, Version=6.4.3056.2005, Culture=neutral, PublicKeyToken=4416dd98f0861965

Assembly Version: 6.4.3056.2005

Exception Source: Interop.Excel

Exception Type: System.Runtime.InteropServices.COMException

Exception Message: Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))

Exception Target Site: get_Version

  • Stack Trace ----

Excel._Application.get_Version()

AddinExpress.MSO.2005.DLL: N 00000 (0x0) JIT

BigFixExcelConnector.FormWizard…ctor()

AddinExpress.MSO.2005.DLL: N 0462 (0x1CE) IL

BigFixExcelConnector.AddinModule.AddinModule_AddinInitialize(sender As Object, e As EventArgs)

AddinExpress.MSO.2005.DLL: N 0001 (0x1) IL

AddinExpress.MSO.ADXAddinModule.Extensibility.IDTExtensibility2.OnStartupComplete(custom As Array&)

AddinExpress.MSO.2005.DLL: N 0572 (0x23C) IL

(Outer Exception)

Date and Time: 06.02.2013 15:03:05

Machine Name: xxx

IP Address: xxx

Current User: xxx

Application Domain: D:\Users\xxx\AppData\Roaming\BigFix Enterprise\Tivoli Endpoint Manager Excel Connector 3.3\

Assembly Codebase: file:///D:/Users/xxx/AppData/Roaming/BigFix Enterprise/Tivoli Endpoint Manager Excel Connector 3.3/AddinExpress.MSO.2005.DLL

Assembly Full Name: AddinExpress.MSO.2005, Version=6.4.3056.2005, Culture=neutral, PublicKeyToken=4416dd98f0861965

Assembly Version: 6.4.3056.2005

Exception Source:

Exception Type: AddinExpress.MSO.ADXExternalException

Exception Message: An error has occured in the code of the add-in.

Exception Target Site: Object reference not set to an instance of an object.

  • Stack Trace ----

any ideas?

Thx in advance!

(imported comment written by Lee Wei)

I think this might be related to the Culture setting on the OS.

When I developed the Excel Connector, I did not specifically manage language and regional settings.

http://www.ibm.com/developerworks/forums/message.jspa?messageID=14894767#14894767

Lee Wei

(imported comment written by SystemAdmin)

Thank you!

That solved my problem.

I changed the date and time format of my OS to English(United States). It was German (Switzerland) before.