I want to establish an OData datafeed in Excel 2013 to connect to a SharePoint 2016 list.

In the Excel, data tab -> from other source -> from OData datafeed. Then I input our SP2016 url:


After some loading, Excel prompt for 401 unauthorized error.

However I can browse https://sharepoint.com/sites/abc/_vti_bin/listdata.svc/mylist with Chrome. I copy the content and saved as a local text file. In the Excel, data tab -> from other source -> browse the text file. Datafeed is imported perfectly.

How can I solve the 401 error?

1 Answer 1


You could try to register excel in SharePoint.


  • The post is talking about App-in. Could you be more specific how to reg the desktop program Excel?
    – Mark L
    Jun 22, 2020 at 1:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.