Sharing excel workbook with locked sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-3440638%22%20slang%3D%22en-US%22%3ESharing%20excel%20workbook%20with%20locked%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3440638%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20company%20uses%20sharepoint%20to%20share%20documents.%20My%20team%20needs%20to%20be%20able%20to%20share%20an%20excel%20workbook%20where%20each%20sheet%20is%20owned%20by%20a%20different%20member%20of%20the%20team.%20We%20want%20to%20be%20able%20to%20have%20each%20sheet%20locked%20to%20each%20individual%20so%20none%20of%20the%20other%20team%20members%20can%20edit%20the%20sheet.%20Is%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20not%2C%20is%20there%20a%20way%20to%20have%20a%20collection%20of%20excel%20workbooks%20but%20have%20them%20all%20be%20searchable%20at%20the%20same%20time%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3440638%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3442641%22%20slang%3D%22en-US%22%3ERe%3A%20Sharing%20excel%20workbook%20with%20locked%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3442641%22%20slang%3D%22en-US%22%3EI%20haven't%20done%20this%2C%20but%20I%20think%20this%20is%20what%20you%20are%20looking%20for%20-%20let%20me%20know.%20You%20could%20probably%20also%20do%20something%20with%20merged%20workbooks%20but%20the%20first%20option%20sounds%20easier%20to%20manage.%3C%2FLINGO-BODY%3E
Occasional Visitor

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. 

1 Reply

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