Urgent help excel sharepoint permissions

[aajufoh]

Thank you for your response. I actually need to perform a task. We are about a team of 10 persons collaborating on a particular microsoft sharepoint excel document. Each person has a specific column on the excel sheet. And we want a situation where every member of the team can only view and edit their specific column on the excel sheet. How can we achieve this?

[#2]

Hello @aajufoh 

Excel inherits the permissions from SharePoint. Your case it's definitivly a Excel question. I'm sure, a Excel pro can help you 😉

Best, Dave

[#3]

You can set permissions by range in Excel. Check out these two articles: https://learn.microsoft.com/en-us/office/troubleshoot/excel/apply-password-to-separate-range and with helpful screenshots https://www.extendoffice.com/documents/excel/1807-excel-allow-certain-users-to-edit.html

Hope that helps!