NAV 2013 R2 - Error exporting to Excel

Franklin · 2013-10-24

Hi everybody.

We are testing Dynamics NAV 2013 R2 and i have encountered the first error. When i export to Excel from Customer List for example, it opens Excel but it launch this error:

Microsoft Dynamics NAV Excel Add-in encountered an external error: URI scheme provided 'localhost' is not valid; it expected 'net.tcp'. Name of parameter: via

I´m working with Office 365

Any idea?? :-k

Capone · 2013-12-30

I had the error "Microsoft Dynamics NAV Excel Add-in encountered an external error: Invalid URI: The URI scheme is not valid."

I got this on a windows server 2012 with excel 2010.

I managed to work around this by uninstalling the excel addin. After that it worked.

ara3n · 2013-12-30

I had the same issue. I had 2013 excel addin installed. I installed 2013 R2 Excel Addin and it solved the problem.

redking · 2014-01-15

Hi Guys,

where do you find the 2013 R2 Excel Addin?
I have the full installation media for NAV 2013 R2 but cannot see anything in there.

Cheers
Red

beran · 2014-01-15

First note that the NAV Excel Add-In is not installed by default in NAV 2013 R2. This might be reason to the problems that some of you see. Since it tries to talk from an NAV Excel Add-In of Nav 2013 to a NAV Server 2013 R2.

The right approach is to go into Control Panel and unistall the NAV Excel Add-in for Nav 2013. Then you start the NAV installer for Nav 2013 R2 and go to the customization, under the Client Customization you add in the NAV Excel Add-in.

We turned off the Excel Add-in by default installation for Nav 2013 R2. The new Excel generator based on OpenXML works both on WinClient and WebClient, it is faster and it gets the data from the page and not just from the table which the Excel Add-In does. This Means that you can see calculated fields on the page. Since the generation is running on the NAV server and just using the OpenXML assembly there is no reason to install Excel on the NAV Server.
Unfortunately the created OpenXML does not have the Refresh button - we tried to find a way for it to use OData but with no success.

geordie · 2014-01-16

beran wrote:

The new Excel generator based on OpenXML works both on WinClient and WebClient, it is faster and it gets the data from the page and not just from the table which the Excel Add-In does. This Means that you can see calculated fields on the page. Since the generation is running on the NAV server and just using the OpenXML assembly there is no reason to install Excel on the NAV Server.
Unfortunately the created OpenXML does not have the Refresh button - we tried to find a way for it to use OData but with no success.

Does the new generator apply also to NAV 2013 or just to 2013 R2? In case, do you think can be downgraded to 2013 or the are any specific requirements?

Thanks

beran · 2014-01-16

Sorry, the new generator does not work for Nav 2013. And we have no intention for back-porting it from NAV 2013 R2 to NAV 2013 - it will simply be too expensive.

geordie · 2014-01-16

beran wrote:

Sorry, the new generator does not work for Nav 2013. And we have no intention for back-porting it from NAV 2013 R2 to NAV 2013 - it will simply be too expensive.

Thanks for feedback

Capone · 2014-02-07

I have to take back my answer. It didn't get "fixed" since I don't have the Dynamics NAV tab in excel which I can refresh.

As I sad before I get the error "Microsoft Dynamics NAV Excel Add-in encountered an external error: Invalid URI: The URI scheme is not valid."

I got this on a windows server 2012 with excel 2010 and it version is all 2013 R2. I have tried to reinstall the excel addin several times without getting it to work

thegunzo · 2014-02-07

Fixed in CU3

https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2918538
https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?scid=kb,en-us,2907590

"Microsoft Dynamics NAV Excel Add-in encountered an external error: Invalid URI: The URI scheme is not valid" error message when you send data to Excel and the Windows client is connected to the NAV server by IP address instead of server name

Capone · 2014-02-07

Cheers! :thumbsup:

VectorK · 2014-07-07

Hi all,

Exporting from customers/vendors lists always print the same email in Nav 2013 R2 (CU8)

Any Ideas?

Thanks

alphageek_uk · 2014-07-14

I am getting the "Microsoft Dynamics NAV Excel Add-in encountered an external error: Invalid URI: The URI scheme is not valid" error with 2013r2 CU9.

I have uninstalled and reinstalled the Excel add-in but that didn't help. Anything else to try?

Lgoo · 2014-07-15

Don´t forgett to Upgrade the RTC and the Service files.

alphageek_uk · 2014-07-15

Lgoo wrote:

Don´t forgett to Upgrade the RTC and the Service files.

Thanks, but: It's a fresh install of the CRONUS demo system from the CU9 media. So, I don't think I have a mismatch between the RTC and the Service Tier.

VectorK · 2014-07-15

In my case was because a customization.

Sorry about that

RemkoD · 2015-02-12

With one of our customers we still have this problem with the Excel plug-in on rollup 10: "Microsoft Dynamics NAV Excel Add-in encountered an external error: Invalid URI: The URI scheme is not valid."

What we've tried so far:
- Reinstalling the client from rollup 10 product dvd
- Fresh rollup 10 NST
- Register fix for the client (previous they had the 103)
- Reinstalling the Excel plugin from the rollup 10 product dvd
- Excluded that the fault is in the database (we’ve made a copy to our local system, could not reproduce)

They use NAV 2013 R2 rollup 10 and Microsoft Office 2010.

Does anyone have a solution or tips for us? :-k

NAV 2013 R2 - Error exporting to Excel

Comments

Categories