与他人共享SharePoint Export Excel文件，并让其他人刷新Excel数据 [英] Share SharePoint Export Excel file with others, and let other refresh the excel data

问题描述

我根据数据可以从SharePoint导出，但是我是唯一可以刷新的数据，我希望让我的同事

I made a pivotchart in excel based on the data exported from SharePoint, but I am the only one who can refresh,  I am hoping to let my colleagues  to refresh, can anyone help me on this? I've been to the regular forum, they told me to come here and I will need to use VBA to do this.

推荐答案

您好，justinChenJTC，

您是否使用ListData.svc从excel连接到SharePoint列表?

您是说人们在上传excel文件后无法刷新excel数据吗?在SharePoint文档库中?

不支持OData数据 在Excel Services和Excel Web App中.

OData data is not supported in Excel Services and Excel Web App.

这里有一些链接供您参考.

https://technet.microsoft.com/en-us/library/jj819452.aspx

https://blogs.technet.microsoft.com/excel_services__powerpivot_for_sharepoint_support_blog/2015/07/28/excel使用listdata-svc/

最好的问候 ，

Best Regards，

陈丽莎

这篇关于与他人共享SharePoint Export Excel文件，并让其他人刷新Excel数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！