none
Share workbook excel functionality RRS feed

  • Question

  • I have a SharePoint 2013 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.  Is this possible in SharePoint 2013?
    Wednesday, April 20, 2016 10:47 AM

Answers

All replies

  • To do Co-Authoring in excel, you need Excel Web Apps.

    Read this

    https://technet.microsoft.com/en-us/library/ff718249.aspx#bkmk_understd



    Wednesday, April 20, 2016 3:44 PM
  • Hi PedroJA,

    As ViviSP suggested, you need to use Excel Web Apps.

    With Office 2010, Office 2013 provides co-authoring functionality for Word 2013, PowerPoint 2013 and OneNote 2013. Office 2013 introduces co-authoring functionality for Visio 2013. If your SharePoint 2013 configured to use Office Web Apps Server, users can also co-author documents in Word, PowerPoint, Excel, and OneNote Web Apps.

    Users can co-author in Excel Web App only if everyone uses the Excel Web App to access the workbook. If anyone uses Excel 2013 or Excel 2010 (the client application) to access the workbook, co-authoring in Excel Web App will be disabled for that workbook while it is open in the client application.

    Best Regards,

    Lisa Chen


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Thursday, April 21, 2016 8:02 AM
    Moderator
  • Hi PedroJA,

    Is there anything update?

    Please remember to mark the replies as answers if they help.

    Have a nice day!

    Best Regards,

    Lisa Chen


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Tuesday, April 26, 2016 12:05 PM
    Moderator