Forum Discussion

Copper Contributor

Nov 02, 2020

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 ...

excel

Ilgar_Zarbaliyev

MCT

Nov 02, 2020

Erwin1882

Hi there,

Please mention the following links:

https://support.microsoft.com/en-us/office/lock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a

https://docs.microsoft.com/en-us/office/troubleshoot/excel/apply-password-to-separate-range

Good luck.

Erwin1882

Copper Contributor

Nov 02, 2020

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.

Ilgar_Zarbaliyev
MCT
Nov 02, 2020
Erwin1882

Thank you for mentioning me.

I will answer to your query tomorrow in the first half of the day (Azerbaijan Time).

Good luck