Permissions

[Erwin1882]

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.

[#2]

@Erwin1882 

Hi there,

Please mention the following links:

https://support.microsoft.com/en-us/office/lock-or-unlock-specific-areas-of-a-protected-worksheet-75...

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

Good luck.

[#3]

@Erwin1882 

* 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)

[#4]

@NikolinoDE , 365 and Windows 10

[#5]

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

[#6]

365? Pro, Web, Home, Personal, etc.?

[#7]

@Erwin1882 

Thank you for mentioning me.

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

Good luck

[#8]

@NikolinoDE , 365 ProPlus

[#9]

@Erwin1882 

I can't help you here other than what Mr. Ilgar_Zarbaliyev  has sent you as info just confirm.

Unfortunately, I cannot reconstruct the problem, I don't have a 365 ProPlus and the necessary experience with 365ProPlus so that I can help you.

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)