Office 2013-在SharePoint中自动连接和更新两个Excel表 [英] Office 2013 - Connect and update automatically two excel tables in sharepoint

问题描述

亲爱的支持

我想连接一个excel表，该表将另外三个excel表与位于Sharepoint中的三个不同数据集进行连接，以便当有人修改这三个excel表时，已编译"列表将被删除.一个会自动更新.我知道在Office 2016 连接到Sharepoint的功能是内置的，但是在我的办公室中我们使用的是Office2013.在我们使用的Office版本中，有没有办法做到这一点?

I would like to connect an excel table compiling three other excel tables with three different data sets located in Sharepoint, so that when someone modifies one of the three, the "compiled" one updates automatically. I know in Office 2016 the feature to connect to sharepoint is inbuilt but in my office we are using Office 2013. I there a way to do that in the version of Office we are using?

谢谢您的帮助

推荐答案

您好，Liljoe，是的，只要两个文件都在SP中即可.有关详细信息，请参见以下链接.它是'10，但在'13中的作用相同:

Hi Liljoe- yes, you can do that as long as both files are in SP. See the following link for details. It's '10, but works the same in '13:

这篇关于Office 2013-在SharePoint中自动连接和更新两个Excel表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！