1

I'm currently having some issues linking Excel to my online calendar (list) whenever I choose the web as a data source and I enter the URL of the calendar I get the option to only import the entire page (The yellow arrow box in top right corner)

Image of error

https://test1.sharepoint.com/sites/ITService/AppsManagement/RetailIntegration/Integration/Lists/Integration%20Team%20Calendar/calendar.aspx

First question...Should I be using the entire link or should be going up a level so to /Integration%20Team%20Calendar/

Secondly - When I choose to import the entire site i get another error which is:

2: Import error I'd be very happy if you could let me know a solution/about this issue

Thanks in advance

  • instead of the calendar.aspx, use the allevents or allitems.aspx, since it's a list of the data. – Mike Jun 6 '16 at 1:28
1

For those who may stumble across this - It's not possible Pre 2013

The link I followed to complete this is as follows:

https://blogs.technet.microsoft.com/excel_services__powerpivot_for_sharepoint_support_blog/2015/07/28/excel-services-consuming-a-sharepoint-list-using-the-listdata-svc/

Thanks anyway guys

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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