How multiple users can open and update it same time in Sharepoint 2010, excel file

Question

_{Friday, March 28, 2014 3:49 PM}

we are using SharePoint 2010, multiple users can open and update the file at same time in SharePoint, I have searched a lot and

read it, some suggestions were can create the file as share work book and then save on Share point and other were its supported only with Office web Apps, Excel Web App, we don't have office Web apps or excel web app, is there any other suggestion,

any help will be great, thanks in advance

All replies (4)

_{Friday, March 28, 2014 5:47 PM ✅Answered}

Hi,

You need office web apps for co-authoring, see Software version requirements for co-authoring in SharePoint 2013 and SharePoint Online section in below link -

http://technet.microsoft.com/en-us/library/ff718249(v=office.15).aspx

and http://office.microsoft.com/en-us/sharepoint-foundation-help/document-collaboration-and-co-authoring-HA102772333.aspx

Edit: Link for SP 2010 http://technet.microsoft.com/en-us/library/ff718249(v=office.14).aspx

Hope this helps!
Ram - SharePoint Architect
Blog - SharePointDeveloper.in
Please vote or mark your question answered, if my reply helps you

_{Friday, March 28, 2014 4:51 PM | 1 vote}

If the file is stored in SharePoint in a library where Checkout is not required, AND your users have the same version of MS Office you can edit the file at the same time using co-authoring. The users can edit the file in their local copy of Excel, and the changes will automatically be merged in the Excel spreadsheet in SharePoint.

w: http://www.the-north.com/sharepoint | t: @JMcAllisterCH | YouTube: http://www.youtube.com/user/JamieMcAllisterMVP

_{Friday, March 28, 2014 5:26 PM}

thanks for quick reply, don't know anything about co-authoring , where I can find about this, and how about  can users edit the file same time on share point or not , is this possible or not ?

_{Friday, March 28, 2014 6:40 PM}

thanks  for your reply,  I will read about these article office web apps and co-authoring .