How can multiple users simultaneously edit SharePoint hosted excel file RRS feed

  • Question

  • Hi,

    I want more than one user to be able to make changes to the excel document in SharePoint at one time and to accept all of the changes made to the document by all users that had it open at the same time without any locking issue. Can you please help on this ? We are using SharePoint 2007 and excel 2007.



    Monday, October 8, 2012 2:23 PM

All replies

  • What version of SharePoint are you using?  If you have Enterprise, you can look at using Excel Services, which is very good for multiple, side by side edits.

    Failing that, what you're asking for isn't possible.  When your users open the file, it'll be downloaded to either the SharePoint Drafts folder (if enabled) or the local temp folder.  Saving the changes made to these files simply uploads the new file to the server.  This operations overrides the previous one.  It doesn't perform any version checking between whats online and what's being saved.  All your users will simply override each others work, if no form of document control or mandatory checking is enabled.

    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    Monday, October 8, 2012 2:28 PM
  • Steven,

    Thanks for the info. I am using Enterprise version of SharePoint 2007. I added the document library to the trusted location of excel services. I am able to 'View in Browser' option, not able to edit through it. No Edit option I could see. Is there an option to Edit the excel file in browser ?



    Wednesday, October 10, 2012 5:34 AM