Forum Discussion
"Allow edit range" permission on Azure AD joined device
Hello.
Many of our users use "Allow edit range" permission in excel. On domain joined devcies, users can search Windows AD to select the user to assign permission. However, on Azure AD joined devcies only local system is listed and thus permission cannot be assigned to a user.
Has anyone faced this issue ad have found a resolution for this? How to use "Allow edit range" permission and select a user from Azure AD?
Same problem. tony-derricott Microsoft Excel OliverScheurich NikolinoDE - Any ideas as Gold contributors?
Excel is traditionally designed for on-premises Active Directory (AD) environments where users can be selected directly from Windows AD.
This is not possible on Azure AD-joined devices as Excel only displays local user accounts, to my knowledge. Currently, there is no direct solution to integrate Azure AD user selection with the Allow Scope Edit feature in Excel.
One possible workaround is to set passwords for specific scopes.
This method does not leverage Azure AD for user-specific permissions, but it does allow for control over who can edit specific scopes based on password distribution.
In case Microsoft provides a better solution, keep an eye on Excel and Azure AD updates.
Hope this helps! 😊
- I also have the same problem, and this option is mandatory for proper cooperation on shared files.
Can any technician help us?- I have the same issue now as we join our devices to INTUNE. Now I'm not able to grant permmison to azure ad users to allow them to edit some ranges. Any update here?
- look forward to the resolution too...
- Same here! Maybe someone has news in this subject?
