NAV 2013 R2 - Error exporting to Excel

FranklinFranklin Member Posts: 253
edited 2015-02-12 in NAV Three Tier
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

Comments

  • CaponeCapone Member Posts: 125
    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.
    Hello IT, have you tried to turn it off and on?
    Have you checked the cables?
    Have you released the filters?

    http://www.navfreak.com
  • ara3nara3n Member Posts: 9,255
    I had the same issue. I had 2013 excel addin installed. I installed 2013 R2 Excel Addin and it solved the problem.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • redkingredking Member Posts: 34
    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
  • beranberan Member, Microsoft Employee Posts: 80
    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.
    Eric Beran
    Software Design Engineer II
    Dynamics NAV Office 365
    Microsoft

    This posting is provided "AS IS" with no warranties, and confers no rights.
  • geordiegeordie Member Posts: 655
    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
  • beranberan Member, Microsoft Employee Posts: 80
    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.
    Eric Beran
    Software Design Engineer II
    Dynamics NAV Office 365
    Microsoft

    This posting is provided "AS IS" with no warranties, and confers no rights.
  • geordiegeordie Member Posts: 655
    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 :wink:
  • CaponeCapone Member Posts: 125
    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 :(
    Hello IT, have you tried to turn it off and on?
    Have you checked the cables?
    Have you released the filters?

    http://www.navfreak.com
  • thegunzothegunzo Member Posts: 274
    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
    ________________________________
    Gunnar Gestsson
    Microsoft Certified IT Professional
    Dynamics NAV MVP
    http://www.dynamics.is
    http://Objects4NAV.com
  • CaponeCapone Member Posts: 125
    Cheers! :thumbsup:
    Hello IT, have you tried to turn it off and on?
    Have you checked the cables?
    Have you released the filters?

    http://www.navfreak.com
  • VectorKVectorK Member Posts: 86
    Hi all,

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

    Any Ideas?

    Thanks
  • alphageek_ukalphageek_uk Member Posts: 5
    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?
  • LgooLgoo Member Posts: 44
    Don´t forgett to Upgrade the RTC and the Service files.
  • alphageek_ukalphageek_uk Member Posts: 5
    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.
  • VectorKVectorK Member Posts: 86
    In my case was because a customization.

    Sorry about that :cry:
  • RemkoDRemkoD Member Posts: 100
    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
Sign In or Register to comment.