Excel locked cells with different permissions for different user groups

Hi Patrick,

Welcome to the Answers community.

We understand you want to give edit permission on specific cells to certain users and I suppose you want to use Allow edit range option, as show below.

If you use this method to lock certain cells, the individuals accessing the workbook online (in SharePoint or Teams) will not be able to edit the workbook, all the cells will be locked even the cells which are allowed for editing.

Based on your requirement, to lock specific cells, I tried the method mentioned in the following article and then shared the workbook, when opening the workbook in browser, I was able to edit the unlocked cells, when I tried to edit the locked ones, I received the following message.

Lock or unlock specific areas of a protected worksheet

I’ll suggest you please try the method from the article, check if this works for you.

Regards,

Neha

Hi Patrick,

Thanks for replying.

To give specific users permission to edit ranges in a protected worksheet your computer must be in a domain. To give permission, you must enter the names of specific users.

May I know where exactly, at which step you are stuck? This will help us understand your scenario.

Regards,

Neha

Hi Patrick,

Thanks for the information.

We understand you would like to add SharePoint Groups in the "Enter the object names to select" box.

The SharePoint groups are specific to SharePoint sites, whereas in "Enter the object names to select" box, we can enter the user’s name those are added to the domain. As SharePoint group are not added to domain, we can’t enter SharePoint group name directly to give permission. In this scenario, we have to enter individual names.

If you need any other help related to this topic, please don’t hesitate to post back.

With sincerest regards,

Neha

Hi Patrick,

File stored in SharePoint online follows the permission level of the site. We can share an entire file and give permission based on the permission group such as full control, edit, contribute etc.

In Excel for the web, you must have noticed there is no Allow edit range feature, there are only basic options, so it won’t be possible to add SharePoint Group to Allow edit range.

Based on the fact, there are two options that comes to my mind, in both the cases, you should Excel desktop application:

1. In the "Enter the object names to select" box, add individual users. You can add the users specifically those are the part of the SharePoint group.
2. You may be able to add permissions as an AD group. Create an AD group similar to a SharePoint group, add the newly AD group to "Enter the object names to select" box.

Kind regards,

Neha