Export to excel for analysis by dimension not worked in Navision 2013 error- Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))

Business Central/NAV Developers Forum
1

Hi Expert,

Please help in resolving the below error-

Client is working on Nav13 and while using of function “Export to Excel” from Analysis by dimension found below error-

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

Thanks.

Regards,

Shweta A.

2

Hi

Try to check the regional settings of your Excel. Hope these links help:

http://vikonav.blogspot.com/2014/08/error-while-interacting-with-excel-old.html?m=1

https://support.microsoft.com/en-in/help/320369/bug-old-format-or-invalid-type-library-error-when-automating-excel

Cheers

3

Thanks for the reply…

after installation of Language interface pack(LIP) it works…!