Forum Discussion
i have problem with cell protection in shared excel
i have shared excel file which is in my OneDrive to 5members by their Microsoft account ID, and i want particular members to edit specific cell range and rest should be protect. i have tried and di...
Unfortunately, it is not currently possible to lock specific cells or ranges in a shared Excel worksheet using Excel for the web. According to a Microsoft Community post, “Excel for the web can’t lock cells or specific areas of a worksheet. If you want to lock cells or protect specific areas, click Open in Excel and lock cells to protect them or lock or unlock specific areas of a protected worksheet”.
You can only lock cells or protect specific areas of a worksheet using the desktop version of Excel.
After protecting the cells in the desktop version of Excel, you can then upload the workbook to OneDrive and share it with others.
The protection will still be in effect when the file is opened in Excel for the web .