NAV 2013 Excel Export. The client version does not match the server version.

sivricmarijan
sivricmarijan Member Posts: 4
in NAV Three Tier
Hello guys and girls.

I have tried to export a page to Excel using NAV "Print & Send" functionality, and I get the following error:
The client version does not match the server version. You can only connect to a server with a matching version.

Client version: 

Server version: 7.1.37563.0

When I make a NAV 2013 R2 repair, everything works fine but Excel export doesn't work in NAV 7.0. I get the following message:
The client version does not match the server version. You can only connect to a server with a matching version.

Client version: 7.1.37563.0

Server version: 7.0.36207.0

When I repair version 7.0, export works OK, but it doesn't work on version 7.1.

How can I fix this? I want the excel export to work on all versions of RTC client.

Comments

  • AdrianAkers
    AdrianAkers Member Posts: 137
    I have tested this before and found that simply it doesn't work where you have multiple versions installed on the same machine... Sorry I have nothing else I can add here.
  • kine
    kine Member Posts: 12,562
    Do not use Excel addin when you have multiple NAV versions. It is simplest. Do you really need the Refresh button in Excel? I never used it...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • sivricmarijan
    sivricmarijan Member Posts: 4
    edited 2015-11-17
    We MUST have this for development/testing purposes. I have multiple versions of NAV installed and I need the "send to Excel" functionality to work on all versions. Is there any way to fix this? I can't repair/reinstall a certain version of NAV every time I need to export something to Excel with it. It's stupid!
  • sivricmarijan
    sivricmarijan Member Posts: 4
    I have found a solution for the problem above! This fixed problem of Excel crashing with some versions of NAV or displaying one of the following error messages:

    5qh02z6tbjjs.png
    ezulbfpfxzh0.png

    1. Start regedit. If version NAV70 doesn't work and the last installed version was NAV80, go to:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\Microsoft.Dynamics.NAV.ExcelAddIn and change the Manifest parameter from:

    file:///C:\Program Files (x86)\Microsoft Dynamics NAV\80\RoleTailored Client\Microsoft.Dynamics.Nav.ExcelAddIn.vsto|vstolocal

    to

    file:///C:\Program Files (x86)\Microsoft Dynamics NAV\70\RoleTailored Client\Microsoft.Dynamics.Nav.ExcelAddIn.vsto|vstolocal

    or whatever version you want to work.

    2. Do the same for HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel\Addins\Microsoft.Dynamics.NAV.ExcelAddIn

    3. Close the Registry Editor and all Excel instances.

    4. Reopen Excel and make sure you have a proper version of NAV Excel Add-in registered inside the Excel (File > Options > Add-Ins):

    0v1s8ylx7dj9.png

    5. Try to send some page to Excel.

    I hope this will help someone.






  • mdPartnerNL
    mdPartnerNL Member Posts: 802
    Will try this, thx
  • frisch
    frisch Member Posts: 20
    edited 2015-11-19
    We have this problem too.
    My colleague just told me that https://navprotocolhandler.codeplex.com/ might work (and it certainly looks easier than editing the registry by hand).

    Will be trying myself, but didn't want to keep it from you :-)
  • sivricmarijan
    sivricmarijan Member Posts: 4
    I tried with NAV protocol handler but it didn't work...maybe I did something wrong
  • sebastian.sidor@icecon.se
    sebastian.sidor@icecon.se Member Posts: 4
    I actually resolved it (at least temporarily) by deleting the entire key (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\Microsoft.Dynamics.NAV.ExcelAddIn). I haven't rebooted the server yet though but without rebooting i can run both nav 2015 and nav 2016 now and export to excel without getting the version error message. Which means that maybe you don't have to change the registry every time you run a new version, and that would be nice. I'll find out tommorrow after reboot if it works !
  • sebastian.sidor@icecon.se
    sebastian.sidor@icecon.se Member Posts: 4
    So this solves the problem, suppose you could also disable the add-in in excel if it's only for one user. However the Dynamics NAV tab disappears so if it's more advanced functionality that you're after and not only the "send to excel" functionality then there's no other way that i know of other then changing the registry.

Categories