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

sivricmarijan

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.

AdrianAkers

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

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...

sivricmarijan

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

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:




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):



5. Try to send some page to Excel.

I hope this will help someone.

mdPartnerNL

Will try this, thx

frisch

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

I tried with NAV protocol handler but it didn't work...maybe I did something wrong

sebastian.sidor@icecon.se

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

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.