I have an Odata connection set up in Excel Services to SharePoint list data. The Odata connection pivots the list data, then charts it in Excel Services, and the chart is hosted in SharePoint When I add SharePoint list data I want the chart to update via Excel Services. I can refresh the data if I open Excel Online, but I can't get the data to auto refresh, or refresh via SharePoint (clicking the chart). I believe this is not working due to trusted locations/authentication, but I'm unsure how to resolve this - if that's the issue. Also, I'm on SP2013 Online - this may also be an issue.

Your Answer

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

Browse other questions tagged or ask your own question.