Lock certain cells on sharepoint online

%3CLINGO-SUB%20id%3D%22lingo-sub-2968537%22%20slang%3D%22en-US%22%3ELock%20certain%20cells%20on%20sharepoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2968537%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20an%20excel%20file%20with%20various%20worksheets%20which%20is%20stored%20on%20a%20sharepoint%20site%20for%20internal%20users%20and%20will%20be%20shared%20to%20some%20guest%20users.%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20lock%20certain%20cells%20for%20the%20guest%20users%20to%20not%20be%20able%20to%20edit%20some%20of%20the%20worksheets%20and%20for%20internal%20users%20to%20be%20able%20to%20edit%20everything%3F%20The%20problem%20is%20on%20sharepoint%20I%20have%20'contribute'%20permissions%20on%20the%20root%20folder%20for%20guests%20%2C%20won't%20they%20be%20able%20to%20edit%20then%3F%20I%20want%20to%20avoid%20protecting%20the%20document%20with%20a%20password%20as%20its%20for%20clients%20to%20see%20too.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2968537%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I have a an excel file with various worksheets which is stored on a sharepoint site for internal users and will be shared to some guest users. 

Is there a way to lock certain cells for the guest users to not be able to edit some of the worksheets and for internal users to be able to edit everything? The problem is on sharepoint I have 'contribute' permissions on the root folder for guests , won't they be able to edit then? I want to avoid protecting the document with a password as its for clients to see too. 

 

Thanks. 

0 Replies