Excel 365 - How to set cell edit permission for Azure users

Supun Karunarathne 0 Reputation points
2023-05-12T09:17:56.11+00:00

Hi,

I need to share a single Excel 365 file among multiple users to allow editing only specified areas. need to prevent editing other people's areas. how to set Azure user authentication for cell ranges.

FOR EXAMPLE,

user01 can edit only yellow area,

user02 can edit grey area

User03 can edit the blue area,.. likewise.

all users are 365 premium users added under the company Azure domain.

Screenshot 2023-05-12 144001

There is an option where I can add local users from my own computer (workgroup).

i am not looking for local user authentication. I want to use Azure users for authentication.

Screenshot 2023-05-12 144524

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,771 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,176 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 30,006 Reputation points Microsoft External Staff
    2023-05-15T09:22:25.9266667+00:00

    Hi,

    I suggest you check if the object type and location is correct:

    User's image

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.