Excel Services - Consuming a SharePoint List using the ListData.svc

Here are the steps I performed to Consume a SharePoint List in Excel Services (SharePoint On Premise): I created a list at this location: http://sp/_layouts/15/start.aspx#/Lists/TomTestList/AllItems.aspx   I then called the listdata.svc from via Excel > Data tab > From Other Sources  > From Odata Feed > http://sp/_vti_bin/listdata.svc I selected my List. I then created a simple…

7

Excel Services - Using a SharePoint List as a data source

Update: You can consume a SharePoint Online list in Excel Online and On Premise if you call the ListData.svc: Excel Online – Consuming SharePoint Listshttp://blogs.technet.com/b/office_online_support_blog/archive/2014/12/17/excel-online-consuming-sharepoint-lists.aspx Excel Services – Consuming a SharePoint List using the ListData.svchttp://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2015/07/28/excel-services-consuming-a-sharepoint-list-using-the-listdata-svc.aspx Since Excel Services inception (SharePoint 2007) users have been attempting to consume a SharePoint List in Excel Services.  Unfortunately this is…

13