Open Forum

 View Only
  • 1.  Office Licenses on Terminal server

    Posted Jun 29, 2022 05:29 PM
    About a month ago we upgraded our GP server from 2012 to 2019.  Ever since then, when we try to export smartlists to excel we get the red bar across the top saying to we need to sign in to office. (I am not sure why we didn't have any issues with server 2012)

    GP sits on the terminal server and the app is published to our desktop.  We do have individual office licenses on our desktop but I guess we do not have licenses on the terminal server.

    I have heard mixed things on how to get this to work.  I have read that if we have a licenses we should just be able to sing in with our own email and pw but I have also read that we need to buy a volume license or a special license for the terminal server since there are multiple people using it.

    I figured I would come here to see how everyone else is set up that uses GP.
    Thank you

    Katie Pieczynski
    Accounts Receivable Manager
    Champaign IL

  • 2.  RE: Office Licenses on Terminal server

    Posted Jun 30, 2022 08:01 AM
    Are you using standard office or office 365?  We use a standard office volume license to install on the RD server. I am not sure how it would work with Office 365.

    Dave Webb
    Prestonsburg KY

  • 3.  RE: Office Licenses on Terminal server

    Posted Jun 30, 2022 09:28 AM
    Hi Katie,
    If you want to work with SmartLists immediately after exporting, you will need Office apps licensed for a Terminal Server.  You could get around that by exporting the file, saving to a network drive, locate the file locally, then open it with your locally-licensed Office software.  If you need to email documents out of GP such as invoices and statements, then I don't know of any workaround and in that case you will need Office for Terminal Servers.

    John Buchman
    Rio Marine

  • 4.  RE: Office Licenses on Terminal server

    Posted Jun 30, 2022 09:39 AM

    Thanks for the reply.

    We have been able to do the work around for smartlist.  The issue we are having now is we have a lot of excel refreshable reports that we cannot manipulate the data because of the license issue.  Most of us are okay because we have the apps published to our desktop and have office on our desktop but we have a few people with Macs and for some reason the way they were set up to access the  GP database and Excel, is different.


    Katie Pieczynski

    Accounts Receivable Manager

    217-531-0620 x 113


If you've found this thread useful, dive deeper into User Group community content by role