I have a setup on sharepoint with an excel data file linked to another excel file containing charts and pivot tables based on this first file. Both files are saved together in a shared folder. I then have a site page which contains the pivots and charts displayed as web parts. I want to be able to refresh only the data file and then see the pivot file and subsequent sit page update without having to open and click refresh on any of the files.
我在sharepoint上设置了一个excel数据文件，该文件链接到另一个包含基于第一个文件的图表和数据透视表的excel文件。两个文件一起保存在共享文件夹中。然后我有一个网站页面，其中包含显示为Web部件的枢轴和图表。我希望能够只刷新数据文件，然后查看数据透视文件和随后的网页更新，而无需打开并单击任何文件上的刷新。
Is this possible?
这可能吗？
1 个解决方案
#1
0
Not sure which version you're using.
不确定您使用的是哪个版本。
For SharePoint 2013, check Configure Excel Services data refresh by using external data connections
对于SharePoint 2013，请使用外部数据连接选中“配置Excel Services数据刷新”
For SharePoint online, you maycheck this demo, while this should require user logon in.
对于SharePoint在线，您可以检查此演示，但这应该要求用户登录。
#1
0
Not sure which version you're using.
不确定您使用的是哪个版本。
For SharePoint 2013, check Configure Excel Services data refresh by using external data connections
对于SharePoint 2013，请使用外部数据连接选中“配置Excel Services数据刷新”
For SharePoint online, you maycheck this demo, while this should require user logon in.
对于SharePoint在线，您可以检查此演示，但这应该要求用户登录。