Hi everyone,
I am dealing with some problem of importing Excel spreadsheet into SP portal. The problem can be reproduced on the web of the same host, but on the second web of this host it is not reproducible.
When I collected the network logs via NPA, I saw that the problematic import is authorized through Bearer, when on a successful import, authorization through NTLM.
The screenshots show the requests coming from the Excel client application.
problem query:
successful query:
My question is: What does the authorization type depend on when importing from Excel? Why on the same host different sites can have different types of authorization?


