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?