1. Extensions
  2. Excel Add-in Series 4
  3. Change authentication settings
  4. Add authentication settings

In series 4 of the Excel Add-in, add an authentication setting.

This enables you to authenticate and set the environment for your Excel Add-in connection.

To add an authentication setting:

  1. Click the arrow below the Sign in icon.
    A drop-down list displays.
  2. Click Authentication Settings.
    The Authentication Settings dialog displays.
  3. In the Authentication Settings dialog, click the add icon (+) at the bottom of the Environments panel.
    A new environment displays in the panel. New environments you add are named Default (1), Default (2), and so on.
Click the plus sign at the bottom-right of the Environments panel to add authentication settings.
  1. If you want you can overwrite Default (1) in the Name field to change the name of the authentication setting.
  2. Enter the connection URL for the environment.
    To check the connection URL is valid, click Test Connection.
    If it's a valid connection, a green checkmark displays. If it's invalid, a red cross displays.
  3. To enable single sign-on (SSO), toggle right SSO Authentication and enter your SSO-friendly URL in the SSO-Friendly URL field.
    After you sign in with SSO for the first time, the Excel Add-in adds ?svcId=auth to the URL. Do not remove this, as it's required for technical reasons.
  4. Choose one of the following options:
    • Click Sign In to sign in.
    • Click OK to save the authentication settings and not sign in.
    • Click Cancel to close the dialog and not save any changes.

Related links: