'Strange hyperlink handling in Excell, clicking on links always prompts for sign in even when it shouldn't
From my enterprise application, I can export a list of assets into an Excel file or a PDF file which puts a clickable hyperlink that points to the asset. When I open the hyperlink in the browser by clicking on the hyperlink in the excel file, my application prompts me to sign in (which it shouldn't).
This doesn't happen when I click on the hyperlink in the PDF file or manually copy the hyperlink and paste it into the browser window. When I save this excel file as a PDF and then click on the hyperlinks then it works as expected(without re-prompt for sign in). I have also manually created hyperlinks both using the formula(=HYPERLINK) and using the Link context menu and the behaviour is the same in these two cases (Prompted for signing). I have also tried this with word and it's also prompting for me to sign in.
Is Excell/MS Office doing anything additional whenever I click on these hyperlinks and if so how can I disable this functionality? How are external URL's handled in the MS office?
My document would look something like below(with a lot more columns)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|