Wednesday 6 August 2014

Error while interacting with Excel "Old format or invalid type library"

Error while interacting with Excel "Old format or invalid type library"

While using Microsoft Office Excel interaction in NAV 2013 you may get the following error message if Language in Excel options doesn't match regional settings on the machine where NAV is running:



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

The simplest way to fix the problem is to set reginal setting and language in Excel to equal values.

2 comments:

  1. The easiest way is first find your system non-unicode setup from Control Panel. Then move to NAV languages to search that code and get the windows language ID. Move to your excel installation folder, copy EXCEL.EXE and then create a new folder named as that windows language ID and put the copied EXCEL.EXE but renamed as xllex.dll

    ReplyDelete
  2. many many thanks for your help

    ReplyDelete