sharepoint 13 import from excel

Question

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?

Answer 1

Hi @Steanly Stevenson ,

Have you configured any custom cloud authentication provider which used bearer token at web application level?

Normally, NTLM authentication method is used in SharePoint server, Bearer token is often used in Azure, such as SharePoint online.

In addition, does "different sites on the same host" mean "a collection of different sites under the Web application"?

We could only create multiple authentication identity providers to a single SharePoint web application, not for different site collections under it.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.