If you Dynamics GP data resides on a different network domain that does your installation of Microsoft Excel, System Administrators can use the JRDS Admin Guide to help them configure the Jet Remote Data Service.
Once that service is set up, users of the Jet Excel add-in can configure a data source to use the service.
Configuring the Data Source Connection
The first step in the Jet add-in is to create a new data source of the type Dynamics GP with a connection type of Remote Data Service. Next, the authentication needs to be configured. The user can authenticate against the JRDS using specified Windows credentials.
It is expected that users will be given a username, domain, and password to use for authentication.
Finally, the Connection information for the instance of the JRDS must be configured:
Note that the Server is the one which is hosting IIS and the JRDS, the Port is the one which was entered into PowerShell when creating the Application Container, and the Instance is the name entered into PowerShell when creating the service instance.
The dropdown to select the company will populate when opened, if the settings are correct.