SteanlyStevenson-0983 avatar image
0 Votes"
SteanlyStevenson-0983 asked JoyZ commented

sharepoint 13 import from excel

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?

problempost.jpg (14.7 KiB)
noproblpost.jpg (7.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

JoyZ avatar image
1 Vote"
JoyZ answered JoyZ commented

Hi @SteanlyStevenson-0983,

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.

image.png (30.2 KiB)
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JulieWang-MSFT,

There is no custom authentication configured. By default, we use NTLM, configured like in your screenshot.

By host, I meant host-named site collection. And in my case there are 2 websites in one site collection. Accordingly, they are located within the same web application.

0 Votes 0 ·
JoyZ avatar image JoyZ SteanlyStevenson-0983 ·

Hi @SteanlyStevenson-0983,

How did you import excel in the host named site collection?

Per my test, I create two HNSC named and, then format the excel as table, export it to different site.

Both of them are successful:



0 Votes 0 ·
image.png (58.6 KiB)
image.png (63.3 KiB)

Hi @JulieWang-MSFT,

I export using options 2 and 3 from your link, the result is the same. I can assume that option 1 will work, because this option does not use the lists.asmx web service. But my question is directly related to export using a web service. I don’t understand why on 2 sites located in the same host-named site collection different types of authorization are used, while only one is configured - NTLM??

0 Votes 0 ·
Show more comments