Steps to Reproduce:-
1. Login into Clarity OnDemand with SSO enabled
2. Go to Project List or any other list view where you can export to excel
3. Select the Export to Excel (data only) option
4. Open the exported Excel document and click over the link to a project with your mouse pointer
Expected Result - A new browser tab/windows is opened with the project details
Actual Result - A new browser tab/windows is asking for credentials in the OnDemand portal
Similarly, if you click on the email notification link, a new browser tab/window opens up asking for credentials in the OnDemand portal.
Why this happens:-
When you click the link from Excel or Outlook, First, Office tries to communicate with the Web server. Then Office tries to directly bind to the resource by using the Microsoft Hyperlink Library (Hlink.dll) and the URLMON API. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
When Office sends the Web page request, you may be redirected to the Web site logon page for the SSO system. This behavior occurs because the Office session is independent of the Web browser session in which you may have already provided user credentials.
Because the sessions are independent, session cookies are not !shared. If the SSO system exclusively relies on session cookie information, the SSO system may not appear to work because the same user moves from more than one session. This behavior is a fundamental design limitation of an SSO system when the SSO system is not designed to support SSO authentication across more than one browser or Web-aware application on the client desktop. Because Office is a fully Web-aware application, the issue may appear unique to Office applications if they are the only Web-aware clients that are installed by the client. However, the root cause of this issue is not limited to Microsoft Office, and this problem may occur when you use third-party software.
Copy the hyperlink from the excel file or email notification and paste into a new browser tab