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.