Adding and activating a profile

Use this procedure to add or activate a profile in Q&A Excel Web Add-in.

Ensure that:
  • Workbook format is .xlsx.
  • You are not in edit mode while using any of Q&A Excel Web Add-in functions.
  1. Open Q&A Excel Web Add-in.
  2. In the Insert tab, click Add-ins .
  3. In the Store tab, specify Query & Analysis Excel Web Add-in in the search field.
  4. In the search results, select Q&A Excel Web Add-in and click Add.
  5. In the Query & Analysis tab, click Authenticate.
  6. Click Environment and select one of the existing authorized profile files or click Upload to add a new profile file.
    Note: Profile files must have .json extension. Sign in to Infor OS Portal and download it from the Q&A management page.
  7. Select a tenant to access and click Back.
  8. Click Sign In and specify your login credentials.
  9. Click Sign In again.
    Once your profile is authenticated, the Sign In and Environment buttons are replaced with the Sign Off button.
    Note: To create more than one profile, follow the same process for each profile.