web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Export to Excel openin...
Microsoft Dynamics AX (Archived)

Export to Excel opening on RDS

(1) ShareShare
ReportReport
Posted on by Community Member

Our users are connected to AX through an RDS server and when exporting to excel the excel file is opening on the RDS server rather than the local machine. The client session option is selected in the AX options and the remote desktop services integration tool has been installed on the local computers. Any idea how to force the client to open on local computer? I users would like to save the files to their local desktop rather than a network location.

Thanks!

Ben

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Export to Excel opening on RDS

    My AX Developers say that Management Reporter is its own module and doesn't integrate with the AX client or local PC.  So server Excel is going to be used.

  • Community Member Profile Picture
    Community Member on at
    RE: Export to Excel opening on RDS

    Does this also apply to Management Reporter reports which are generated via RDS client yet they seem to open with a server instance of Excel?

  • Community Member Profile Picture
    Community Member on at
    RE: Export to Excel opening on RDS

    Thank you so much for this information!  I put the entries in HKLM instead and it works for all users on the PC.  We now can use a SCCM task sequence to install the add-in, also adding the registry changes to HKLM.  This solves a huge problem of getting the add-ins installed on hundreds of PCs, many of them shared, without user intervention.

    64-bit:

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Terminal Server Client\Default]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Terminal Server Client\Default\Addins]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Terminal Server Client\Default\Addins\VirtualChannelClient]

    "Name"="C:\\Program Files (x86)\\Microsoft Dynamics AX\\60\\OfficeAddins\\Microsoft.Dynamics.Ax.VirtualChannelClient.dll:

    {3BD45576-CA26-4603-A619-E264F1D10664}"

    32-bit:

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Terminal Server Client\Default]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Terminal Server Client\Default\Addins]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Terminal Server Client\Default\Addins\VirtualChannelClient]

    "Name"="C:\\Program Files\\Microsoft Dynamics AX\\60\\OfficeAddins\\Microsoft.Dynamics.Ax.VirtualChannelClient.dll:{3BD45576-

    CA26-4603-A619-E264F1D10664}"

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Export to Excel opening on RDS

    Thank you so much for this information!  I put the entries in HKLM instead and it works for all users on the PC.  We now can use a SCCM task sequence to install the add-in, also adding the registry changes to HKLM.  This solves a huge problem of getting the add-ins installed on hundreds of PCs, many of them shared, without user intervention.

    64-bit:

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Terminal Server Client\Default]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Terminal Server Client\Default\Addins]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Terminal Server Client\Default\Addins\VirtualChannelClient]

    "Name"="C:\\Program Files (x86)\\Microsoft Dynamics AX\\60\\OfficeAddins\\Microsoft.Dynamics.Ax.VirtualChannelClient.dll:{3BD45576-CA26-4603-A619-E264F1D10664}"

    32-bit:

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Terminal Server Client\Default]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Terminal Server Client\Default\Addins]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Terminal Server Client\Default\Addins\VirtualChannelClient]

    "Name"="C:\\Program Files\\Microsoft Dynamics AX\\60\\OfficeAddins\\Microsoft.Dynamics.Ax.VirtualChannelClient.dll:{3BD45576-CA26-4603-A619-E264F1D10664}"

    -Russell

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,611 Super User 2025 Season 2 on at
    RE: Export to Excel opening on RDS

    Hi Ben,

    If the problem has been solved, would you mind to mark the correct answer(s)? Propably one from Douglas and your great summary.

  • Manmeet Kaur Profile Picture
    Manmeet Kaur 2 on at
    RE: Export to Excel opening on RDS

    Solution provided by Ben Tarney worked for us. Just make sure put the correct - 32 or 64, bit setting.

  • Douglas Noel Profile Picture
    Douglas Noel 3,905 on at
    RE: Export to Excel opening on RDS

    Hi Ben

    thanks for this info.

    This seems to be another "non rdp server security related" issue.  I don't know why the client virtual channel registration is located in the HKCU hive.  This seems to be not very useful.  I am going to check this the next days - if the installtion of RemoteDesktopTools will really install the extension only for the person who is installing?

    But maybe - I don't really know - this "By User registration on the client side" will influence the security settings on the server side?

    But this could be really helpful for other users running in the same trouble.

    Thank you for sharing this information.

    regards

    Douglas

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Export to Excel opening on RDS

    I found a registry setting on my log-in that when apply to additional users fixed the issue. This tells the rdp client to use the Remote Desktop Services Integration dll.

    Douglas thanks for pointing me on the right path!

    Registy Entries that worked for me:

    Copy and paste in a text editor and then save with .reg file extension. Double Click to run.

    64 bit:

    Windows Registry Editor Version 5.00

    [HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client\Default\AddIns\VirtualChannelClient]

    "Name"="C:\\Program Files (x86)\\Microsoft Dynamics AX\\60\\OfficeAddins\\Microsoft.Dynamics.Ax.VirtualChannelClient.dll:{3BD45576-CA26-4603-A619-E264F1D10664}"

    32 Bit:

    Windows Registry Editor Version 5.00

    [HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client\Default\AddIns\VirtualChannelClient]

    "Name"="C:\\Program Files\\Microsoft Dynamics AX\\60\\OfficeAddins\\Microsoft.Dynamics.Ax.VirtualChannelClient.dll:{3BD45576-CA26-4603-A619-E264F1D10664}"

  • Douglas Noel Profile Picture
    Douglas Noel 3,905 on at
    RE: Export to Excel opening on RDS

    Here is some interesting link. Seems to be more people having trouble with the security settings for rdp under 2012 OS.

    social.technet.microsoft.com/.../where-is-the-remote-desktop-session-host-configuration-tool-in-server-2012-

    regards

    Douglas

  • Douglas Noel Profile Picture
    Douglas Noel 3,905 on at
    RE: Export to Excel opening on RDS

    Sorry Ben,

    there are a lot of changes with the whole RDP stuff in 2012 OS.

    I've no idea at the moment.

    Maybe you can post your results if you find out something.

    regrads

    Douglas

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans