Excel - Customize protection to have multiple users with varied access and permission of a worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1191148%22%20slang%3D%22en-US%22%3EExcel%20-%20Customize%20protection%20to%20have%20multiple%20users%20with%20varied%20access%20and%20permission%20of%20a%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1191148%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20Excel%20is%20it%20possible%20to%20customize%20protection%2Faccess%20per%20multiple%20users%3F%26nbsp%3B%20Can%20you%20have%20multiple%20users%20that%20log%20in%20to%20a%20worksheet%20and%20each%20user%20have%20a%20customized%20varied%20access%20and%20permission%20of%20the%20worksheet%3F%26nbsp%3B%20How%20is%20this%20done%3F%26nbsp%3B%20Thank%20you%20for%20your%20assistance.%3C%2FP%3E%3CP%3EMarcy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1191148%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1191537%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Customize%20protection%20to%20have%20multiple%20users%20with%20varied%20access%20and%20permission%20of%20a%20works%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1191537%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F566790%22%20target%3D%22_blank%22%3E%40Marcy619%3C%2FA%3E%26nbsp%3BYou%20can%20use%20Azure%20Information%20Protection%20and%2For%20Sensitivity%20Labels%20to%20achieve%20this%2C%20e.g.%20some%20users%20can%20edit%20and%20copy%20data%20within%20Excel%2C%20others%20can%20only%20edit%20and%20some%20can%20only%20view%20the%20data.%20This%20kind%20of%20protection%20travels%20with%20the%20file.%20I%20suggest%20you%20check%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fcompliance%2Fsensitivity-labels%3Fview%3Do365-worldwide%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fcompliance%2Fsensitivity-labels%3Fview%3Do365-worldwide%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlternatively%2C%20you%20just%20set%20different%20permissions%20on%20where%20the%20workbook%20is%20stored%20if%20that's%20good%20enough%20for%20you%20(e.g.%20some%20users%20can%20edit%20the%20Excel%20file%2C%20others%20have%20read-only%20access).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1191556%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Customize%20protection%20to%20have%20multiple%20users%20with%20varied%20access%20and%20permission%20of%20a%20works%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1191556%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111%22%20target%3D%22_blank%22%3E%40Pavel%20Otych%3C%2FA%3E%26nbsp%3B%20Thank%20you%20for%20the%20response.%26nbsp%3B%20I%20was%20looking%20to%20know%20more%20about%20actual%20changes%20to%20data%20in%20a%20worksheet%20and%20giving%20permissions%20to%20some%20and%20not%20to%20others%20and%20giving%20some%20permissions%20to%20change%20certain%20cell%20content%20while%20others%20can%20change%26nbsp%3B%20a%20different%20set%2Frange%20of%20cell%20content%20-%20vs%20-%20security%2Ffirewall.%26nbsp%3B%20Is%20is%20possible%20to%20give%20multiple%20users%20varied%20permissions%20to%20a%20worksheet%20with%20varied%20access%20to%20cells%2Franges%20and%20what%20each%20user%20can%20change%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1191606%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Customize%20protection%20to%20have%20multiple%20users%20with%20varied%20access%20and%20permission%20of%20a%20works%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1191606%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F566790%22%20target%3D%22_blank%22%3E%40Marcy619%3C%2FA%3E%26nbsp%3BOh%2C%20I%20see%20what%20you%20mean.%20Such%20a%20thing%20is%20not%20possible%20with%20AIP%2FSensitivity%20labels%20-%20the%20permissions%20are%20set%20for%20the%20whole%20workbook%2C%20you%20cannot%20set%20different%20permissions%20for%20specific%20cells%2Franges.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20there%20is%20such%20a%20feature%20in%20Excel%20which%20allows%20access%20to%20specific%20ranges%20to%20specific%20domain%20users%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Flock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Flock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a%3C%2FA%3E%26nbsp%3BI%20have%20no%20experience%20with%20that%20though.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1196254%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Customize%20protection%20to%20have%20multiple%20users%20with%20varied%20access%20and%20permission%20of%20a%20works%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1196254%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111%22%20target%3D%22_blank%22%3E%40Pavel%20Otych%3C%2FA%3E%26nbsp%3BSure%20do%20appreciate%20your%20help.%26nbsp%3B%20Thank%20you.%26nbsp%3B%20I%20am%20looking%20into%20your%20suggestion.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

In Excel is it possible to customize protection/access per multiple users?  Can you have multiple users that log in to a worksheet and each user have a customized varied access and permission of the worksheet?  How is this done?  Thank you for your assistance.

Marcy

4 Replies
Highlighted

@Marcy619 You can use Azure Information Protection and/or Sensitivity Labels to achieve this, e.g. some users can edit and copy data within Excel, others can only edit and some can only view the data. This kind of protection travels with the file. I suggest you check https://docs.microsoft.com/en-us/microsoft-365/compliance/sensitivity-labels?view=o365-worldwide 

 

Alternatively, you just set different permissions on where the workbook is stored if that's good enough for you (e.g. some users can edit the Excel file, others have read-only access).

Highlighted

@Pavel Otych  Thank you for the response.  I was looking to know more about actual changes to data in a worksheet and giving permissions to some and not to others and giving some permissions to change certain cell content while others can change  a different set/range of cell content - vs - security/firewall.  Is is possible to give multiple users varied permissions to a worksheet with varied access to cells/ranges and what each user can change?

Highlighted

@Marcy619 Oh, I see what you mean. Such a thing is not possible with AIP/Sensitivity labels - the permissions are set for the whole workbook, you cannot set different permissions for specific cells/ranges. 

 

However, there is such a feature in Excel which allows access to specific ranges to specific domain users - https://support.office.com/en-us/article/lock-or-unlock-specific-areas-of-a-protected-worksheet-7548... I have no experience with that though.

Highlighted

@Pavel Otych Sure do appreciate your help.  Thank you.  I am looking into your suggestion.