Allow editable ranges in Excel Online
As with the 'offline' version, be able to protect sheets/workbooks and allow editable ranges.
Excel Online defaults to protecting the entire sheet,
As shared excel files/reporting are a large part of the new apps (MS Teams) it would make sense that this feature is included in the Online Excel version.
Benjamin Hanna commented
Hugely relevant to give the ability to workflow something to Excel online while preventing receiving team from deleting that data. This makes the workflow more likely to occur and be maintained, when groups really only need modifiable means of communicating regarding static data.
Sandip C Patel commented
This is a crucial feature that keeps Google Sheets relevant. Having the ability to restrict ranges by user using the Excel Online Platform could be a very powerful tool, and frankly, has become a necessity. Those users should also auto-populate based on the Office 365 User listing. We have migrated more than 50 spreadsheets alone from Google Suite to Office 365, however our one major file that is used by over 50 users cannot be migrated over for this simple reason.
Chris Moody commented
We want to move staff from Google Drive, but this is a sticking point as they use in in Google and it does not come across and work in an online shared spreadsheet as it should.