Protect Range/Sheet, Collaboration Range/Sheet, Tracking history of workbook
There are several functions that don't work the same in the online version vs desktop. Besides that, in comparison, Microsoft Excel Online doesn't have advanced features in the Google Sheets. Below are a few that are particularly frustrating to me so far:
~ Protecting features only works in desktop version (not work online)
~ Microsoft Excel Only cannot protect sheets, but Google Sheets can protect sheets or ranges. Therefore, many users can collaborate together with high security in range/ranges, same sheet/sheets in a common workbook.
~ and so many advanced other feature in Google Sheets doesn't appear in Microsoft Excel
~ With Google Sheets, user can collaborate online and track history of workbook to go back (if need). This feature is so interesting and useful but have not appeared in Microsoft Excel Online.
This is an important feature to enable multiple users to input their data, while ensuring spreadsheet integrity. Please add it. I do not have the possibility of using the desktop version.
Paul M commented
Please add this feature or else 365 is not a viable alternative to Google G-suite.
We need this feature added into the web version. Our company (6000 staff) is now using this system state wide and we need to lock the cells to protect the integrity of the document plus allow edits from off site in real time - especially if there is a document error as it will affect the running of the program.
We're currently using google cloud. If it doesn't change, we will stay with google cloud.
John the bohn commented
Please add an option to unprotect a protected sheet in Excel for the Web (Excel Online)
Henri Ashba commented
Would like to lock some cell per user on an online excel sheet