May 27 2022 05:07 PM
Hi,
My company uses sharepoint to share documents. My team needs to be able to share an excel workbook where each sheet is owned by a different member of the team. We want to be able to have each sheet locked to each individual so none of the other team members can edit the sheet. Is this possible?
If not, is there a way to have a collection of excel workbooks but have them all be searchable at the same time?
Thank you.
May 29 2022 08:37 AM - edited May 29 2022 08:38 AM
I haven't done this, but I think this is what you are looking for - let me know. You could probably also do something with merged workbooks but the first option sounds easier to manage. Apply different passwords or permissions to separate ranges in workbooks - Office | Microsoft Docs