Excel Protection

%3CLINGO-SUB%20id%3D%22lingo-sub-434809%22%20slang%3D%22en-US%22%3EExcel%20Protection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-434809%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20working%20in%20an%20excel%20worksheet%20that%20is%20accessible%20to%20other%20staff%2C%20is%20there%20a%20way%20to%20protect%20the%20worksheet%20from%20being%20edited%20by%20one%20user%20while%20being%20used%20by%20another%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-434809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-435140%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Protection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-435140%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F319133%22%20target%3D%22_blank%22%3E%40Hils7405%3C%2FA%3E%26nbsp%3B%2C%20if%20you%20share%20workbook%20you%20may%20do%20that%20on%20file%20level%20(file%20share%2C%20Sharepoint%2C%20whatever)%20giving%20one%20users%20read%20only%20access%20and%20full%20access%20to%20others%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi,

 

When working in an excel worksheet that is accessible to other staff, is there a way to protect the worksheet from being edited by one user while being used by another?

1 Reply

@Hils7405 , if you share workbook you may do that on file level (file share, Sharepoint, whatever) giving one users read only access and full access to others