帮助Excel文件和SharePoint列表之间的连接,以便Excel Web部件可以刷新 [英] Help with connection between Excel file and SharePoint list so that Excel web part can refresh
问题描述
我有一个网页部件页面,显示存储在网站文档库中的Excel文件中的数据透视表。 当我尝试刷新数据时,我收到"外部数据刷新失败"的消息。我打开文件,看了
连接属性对话框。 连接文件的路径指向我计算机上的c:\ Users \文件夹。 这似乎不对。 这是在我的计算机上编辑Excel并将其重新上传到库中的结果吗?
由于刷新失败,我这样做了。我看到有一个导出连接文件,但我不知道如果我导出它应该存储在哪里。 它应该只是进入我的文档库还是有特殊的位置?
没有错误;每个结果都会告诉你有关你想要完成什么的一些有价值的东西。
I have a web part page that is displaying pivot tables from an Excel file stored in the site's document library. When I try to refresh data I am getting a message that the "External Data Refresh Failed." I opened the file and looked at the Connection Properties dialog box. The path to the connection file is pointing to my c:\Users\ folder on my computer. This doesn't seem right. Is this a result of editing the Excel on my computer and re-uploading it to the library? I have done this because of the refresh fail. I see there is an Export Connection File, but I don't know where I should store that if I export it. Should it just go in my document library or is there a special location for them?
There are no mistakes; every result tells you something of value about what you are trying to accomplish.
推荐答案
我解决这个问题的方法是将数据与图表。
The way I solve this is to separate the data from the charts.
因此,charts.xls链接到本地计算机上的data.xls。
So, charts.xls is linked to data.xls on your local machine.
将它们同时上载到SharePoint文档图书馆。
打开Charts.xls,它应该自动链接到SharePoint data.xls
Upload them BOTH to the SharePoint document library.
Open Charts.xls, and it should auto-link to the SharePoint data.xls
然后,当你想修改数据时,修改data.xls在本地计算机上,然后再次将新数据版本上载到文档库。在SharePoint上重新打开charts.xls,它应该再次自动链接。 (如果没有,请使用向导重新连接。)
Then, when you want to modify the data, modify data.xls on your local machine, and then upload the new data version to the document library again. Re-open the charts.xls on SharePoint, and it should, again, auto-link. (If not, use a wizard to reconnect.)
(我老了...... xls = xlsx。)
(I'm so old school... xls = xlsx.)
这篇关于帮助Excel文件和SharePoint列表之间的连接,以便Excel Web部件可以刷新的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!