My company has switched from Google Docs to SharePoint and Office 365. One of the things that we need to be able to do is have a collaborative live/dynamic spreadsheet that give lock some cells to some people and give access to others. This was capable on Google Docs; can I do this on SharePoint?


  1. Open your Excel Online Spreadsheet, and select to edit the spreadsheet in Excel (not Excel Online).
  2. On the REVIEW tab select Allow Users to Edit Ranges in the Changs Group
  3. Click New and select cells to restrict
  4. Click Permissions... and chose the group that are allowed to edit (and select Allow).
  5. Click OK to save the setting and save your Excel Online Workbook.

enter image description here

  • im trying to test this scenario in SharePoint 2013 . two users can open file in excel web app and edit cells simultaneously but this in not worked. any of three limited active directory accounts edit anywhere they want and not applied any restrictions!! any suggestion?? one of users not admin. one of users is SharePoint Farm admin. – saber tabatabaee yazdi Jan 10 '18 at 7:45

Not the answer you're looking for? Browse other questions tagged or ask your own question.