As a part of the new localized NAV 2013 we need to configure the Rapid Start package to be used with new installations.  As we started to work with the packages trying to export to Excel we got an error.

ExcelLocalizationError

The cause is known by Microsoft.

You receive this error calling an Excel method when the   following conditions are true:   

  • The method requires an LCID (locale identifier).
  • You run an English version of Excel. However, the regional settings for the computer are configured for a non-English language.

If the client computer runs the English version of Excel and the locale for the current user is configured for a language other   than English, Excel will try to locate the language pack for the configured   language. If the language pack is not found, the error is reported.

We saw the same error in NAV 2009 R2 Role Tailored Client.  The solution is simple, download and install a language pack for Microsoft Office that matches your regional settings.  You should find the language pack on the Office Language Interface Pack (LIP) downloads page.

Link for Office 2016

 

5 thoughts on “Old format or invalid type library Excel error in Rapid Start

  1. Thanks. And strange the error goes away as soon as you have installed the language pack, even when you don’t enable it.
    May I suggest that you in the future writes the error message into your post, when only using a image with the error massage, then it’s not getting correctly indexed by search engines.
    “Old format or invalid type library.
    (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))”

    1. Thanks Erik.
      Will do that from now on.

  2. Jim says:

    No language pack for Spanish I see..Oh dear, what a goof!

  3. Hi guys,

    What is the solution for office 365? This above solution applies for :

    Applies To: Excel 2013, Excel 2007, Excel 2010, OneNote 2010, Outlook 2013, Outlook 2007, Outlook 2010, PowerPoint 2007, PowerPoint 2010, Word 2013, Word 2007, Word 2010, OneNote 2013, PowerPoint 2013

  4. Wesley Yu says:

    The easiest way is first find your system non-unicode setup from Control Panel. Then search that 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

Leave a Reply

%d bloggers like this: