Forum Discussion
Permissions
I've used "Allow Edit Ranges" to give permissions to specific people to access to specific areas in a spreadsheet. The spreadsheet is being shared through OneDrive. The problem is, once individuals log into those areas, they are open for everyone to edit. Why? Is there a way to limit editing access to certain individuals only? I'm using 365 ProPlus and Windows 10.
8 Replies
Apply different passwords or permissions to separate ranges in workbooks in Excel
https://docs.microsoft.com/en-us/office/troubleshoot/excel/apply-password-to-separate-range
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
- 365? Pro, Web, Home, Personal, etc.?
NikolinoDE , 365 ProPlus
* Knowing the Excel version and operating system would also be an advantage.
So you can get a solution that is tailored to your needs much faster.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
NikolinoDE , 365 and Windows 10
Hi there,
Please mention the following links:
https://docs.microsoft.com/en-us/office/troubleshoot/excel/apply-password-to-separate-range
Good luck.
Ilgar_Zarbaliyev , I've read those and I've followed those steps. The problem is, when a range is unlocked by someone, anyone else is able to edit those ranges.
Thank you for mentioning me.
I will answer to your query tomorrow in the first half of the day (Azerbaijan Time).
Good luck
