Symptom
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))
-------------------------------------
Environment
Analysis for Microsoft Office
Cause
This is a Microsoft bug described in the article BUG: "Old format or invalid type library" error when automating Excel.
Resolution
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.
Keywords
da39-a3ee-5e, 0x80028018, TYPE_E_INVDATAREAD, formula, error , KBA , BI-RA-AO-XLA , Excel Addin , Problem