I have a SharePoint 2010 site with a document library for storing Excel files. If someone is editing an Excel file (using stand-alone Excel, not Excel services), everyone else will be forced to open the file read-only until the first person is done editing. Is there a way around this? What I want is to allow two or more people to be able to edit the file at the same time. Also, I don't want people to overwrite each other. Instead, I'd like SharePoint to merge their changes. Is this possible in SharePoint 2010?
我有一个SharePoint 2010站点，其中包含一个用于存储Excel文件的文档库。如果有人正在编辑Excel文件(使用独立的Excel，而不是Excel服务)，其他人将*以只读方式打开文件，直到第一个人完成编辑。有办法解决这个问题吗?我想要的是允许两个或更多的人同时编辑文件。而且，我不希望人们互相覆盖。相反，我希望SharePoint合并他们的变更。2010年的SharePoint有可能吗?
5 个解决方案
#1
16
No, sadly:
不,不幸的是:
The Excel 2010 client application does not support co-authoring workbooks in SharePoint Server 2010. However, the Excel client application does support non-real-time co-authoring workbooks stored locally or on network (UNC) paths by using the Shared Workbook feature. Co-authoring workbooks in SharePoint is supported by using the Microsoft Excel Web App, included with Office Web Apps
Excel 2010客户端应用程序不支持SharePoint Server 2010中的协同编写工作簿。但是，Excel客户机应用程序使用共享的工作簿特性，支持在本地或网络(UNC)路径中存储的非实时协作编写工作簿。SharePoint中的协同创作工作簿支持使用Microsoft Excel Web应用程序，包括Office Web应用程序
From Co-authoring overview (SharePoint Server 2010)
从共同创作概述(SharePoint Server 2010)
...and not for SharePoint 2013 either. Though it works for pretty much all other Office documents. Go figure.
…2013年的SharePoint也是如此。尽管它适用于几乎所有其他的办公文档。图。
#2
1
The new version of SharePoint and Office (SharePoint 2010 and Office 2010) respectively are supposed to allow for this. This also includes the web based versions. I have seen Word and Excel in action do this, not sure about other client applications.
SharePoint和Office的新版本(SharePoint 2010和Office 2010)都应该考虑到这一点。这也包括基于web的版本。我曾见过Word和Excel在实践中这么做，但对其他客户端应用程序并不确定。
I am not sure about the specific implementation features you are asking about in terms of security though. Sorry.,=
我不确定您所问的关于安全性的具体实现特性。对不起,=
Here is a discussion
这是一个讨论
http://blogs.msdn.com/b/sharepoint/archive/2009/10/19/sharepoint-2010.aspx
http://blogs.msdn.com/b/sharepoint/archive/2009/10/19/sharepoint - 2010. aspx
#3
0
Yes you can. I've used it with Word and PowerPoint. You will need Office 2010 client apps and SharePoint 2010 foundation at least. You must also allow editing without checking out on the document library.
是的,你可以。我用过Word和PowerPoint。你至少需要Office 2010客户端应用程序和SharePoint 2010 foundation。您还必须允许在不签出文档库的情况下进行编辑。
It's quite cool, you can mark regions as 'locked' so no-one can change them and you can see what other people have changed every time you save your changes to the server. You also get to see who's working on the document from the Office app. The merging happens on SharePoint 2010.
这很酷，您可以将区域标记为“locked”，这样就没有人可以更改它们，并且您可以在每次将更改保存到服务器时看到其他人更改了什么。您还可以从Office应用程序中看到谁在处理文档。合并发生在SharePoint 2010上。
#4
0
Unfortunately, the file must be locked for updates unless you're using Office 2010 and SharePoint 2010 together. This means that only one user per time can edit a file. The locking and version tracking capabilities of SharePoint are excellent, and this makes it a great tool for the type of collaboration you're talking about, but you would have to split documents into multiple files in order to extend the amount that could be edited at a time. For instance, we sometimes unmerge documents into technical, requirements, and financials sections so that the 3 experts required for the review can work concurrently. We then merge when everyone is finished.
不幸的是，除非您同时使用Office 2010和SharePoint 2010，否则文件必须被锁定进行更新。这意味着每次只有一个用户可以编辑文件。SharePoint的锁定和版本跟踪功能非常出色，这使它成为您正在谈论的协作类型的一个很好的工具，但是您必须将文档分割成多个文件，以便在一次中扩展可编辑的数量。例如，我们有时将文档合并到技术、需求和财务部分中，以便评审所需的3位专家可以同时工作。当每个人都完成时，我们就合并。
#5
0
yes if it is SharePoint 2010 and above by using the Office feature co-authoring
如果是SharePoint 2010或以上版本，可以使用Office功能协同创作
#1
16
No, sadly:
不,不幸的是:
The Excel 2010 client application does not support co-authoring workbooks in SharePoint Server 2010. However, the Excel client application does support non-real-time co-authoring workbooks stored locally or on network (UNC) paths by using the Shared Workbook feature. Co-authoring workbooks in SharePoint is supported by using the Microsoft Excel Web App, included with Office Web Apps
Excel 2010客户端应用程序不支持SharePoint Server 2010中的协同编写工作簿。但是，Excel客户机应用程序使用共享的工作簿特性，支持在本地或网络(UNC)路径中存储的非实时协作编写工作簿。SharePoint中的协同创作工作簿支持使用Microsoft Excel Web应用程序，包括Office Web应用程序
From Co-authoring overview (SharePoint Server 2010)
从共同创作概述(SharePoint Server 2010)
...and not for SharePoint 2013 either. Though it works for pretty much all other Office documents. Go figure.
…2013年的SharePoint也是如此。尽管它适用于几乎所有其他的办公文档。图。
#2
1
The new version of SharePoint and Office (SharePoint 2010 and Office 2010) respectively are supposed to allow for this. This also includes the web based versions. I have seen Word and Excel in action do this, not sure about other client applications.
SharePoint和Office的新版本(SharePoint 2010和Office 2010)都应该考虑到这一点。这也包括基于web的版本。我曾见过Word和Excel在实践中这么做，但对其他客户端应用程序并不确定。
I am not sure about the specific implementation features you are asking about in terms of security though. Sorry.,=
我不确定您所问的关于安全性的具体实现特性。对不起,=
Here is a discussion
这是一个讨论
http://blogs.msdn.com/b/sharepoint/archive/2009/10/19/sharepoint-2010.aspx
http://blogs.msdn.com/b/sharepoint/archive/2009/10/19/sharepoint - 2010. aspx
#3
0
Yes you can. I've used it with Word and PowerPoint. You will need Office 2010 client apps and SharePoint 2010 foundation at least. You must also allow editing without checking out on the document library.
是的,你可以。我用过Word和PowerPoint。你至少需要Office 2010客户端应用程序和SharePoint 2010 foundation。您还必须允许在不签出文档库的情况下进行编辑。
It's quite cool, you can mark regions as 'locked' so no-one can change them and you can see what other people have changed every time you save your changes to the server. You also get to see who's working on the document from the Office app. The merging happens on SharePoint 2010.
这很酷，您可以将区域标记为“locked”，这样就没有人可以更改它们，并且您可以在每次将更改保存到服务器时看到其他人更改了什么。您还可以从Office应用程序中看到谁在处理文档。合并发生在SharePoint 2010上。
#4
0
Unfortunately, the file must be locked for updates unless you're using Office 2010 and SharePoint 2010 together. This means that only one user per time can edit a file. The locking and version tracking capabilities of SharePoint are excellent, and this makes it a great tool for the type of collaboration you're talking about, but you would have to split documents into multiple files in order to extend the amount that could be edited at a time. For instance, we sometimes unmerge documents into technical, requirements, and financials sections so that the 3 experts required for the review can work concurrently. We then merge when everyone is finished.
不幸的是，除非您同时使用Office 2010和SharePoint 2010，否则文件必须被锁定进行更新。这意味着每次只有一个用户可以编辑文件。SharePoint的锁定和版本跟踪功能非常出色，这使它成为您正在谈论的协作类型的一个很好的工具，但是您必须将文档分割成多个文件，以便在一次中扩展可编辑的数量。例如，我们有时将文档合并到技术、需求和财务部分中，以便评审所需的3位专家可以同时工作。当每个人都完成时，我们就合并。
#5
0
yes if it is SharePoint 2010 and above by using the Office feature co-authoring
如果是SharePoint 2010或以上版本，可以使用Office功能协同创作