Apr 06 2023 01:48 AM
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 didn't got any options for that.
pls help me out
Apr 06 2023 02:03 AM
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 .
Apr 06 2023 02:18 AM
Apr 06 2023 05:53 AM
In the desktop version of Excel 365, you can share specific cells or ranges with specific users while the rest of the worksheet remains protected.
Here are the steps you can follow:
After protecting the cells in the desktop version of Excel, you can upload the workbook to OneDrive and share it with others.
The protection remains in effect even when the file is opened in Excel for the web.
If you want to use it for educational or sales purposes and want to be sure, click this link.
I hope this helps!
Apr 06 2023 05:54 AM
Apr 07 2023 05:46 AM
your right, that Permissions are done through the Active Directory and not MS accounts. and that's what i thought before and you have clarified me.
i still think, its better feature, if Microsoft provides.
Apr 07 2023 05:53 AM