3148555 - Exception "[da39-a3ee-5e] Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))"

The exception below occurs in Analysis Office when using formula SAPGetData:

-------------------------------------
[da39-a3ee-5e] Exception has been thrown by the target of an invocation.:
[da39-a3ee-5e] Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
-------------------------------------

Analysis for Microsoft Office

This is a Microsoft bug described in the article BUG: "Old format or invalid type library" error when automating Excel.

Workaround:

Install the language pack of Microsoft Office used in the Windows Region settings from Language Accessory Pack for Office.

For example: if using "Portuguese" in the Region settings of Windows, install the "Portuguese" pack from the link above.

da39-a3ee-5e, 0x80028018, TYPE_E_INVDATAREAD, formula, error , KBA , BI-RA-AO-XLA , Excel Addin , Problem