Setting permissions to different users to access different spreadsheets within the same workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2613147%22%20slang%3D%22en-US%22%3ESetting%20permissions%20to%20different%20users%20to%20access%20different%20spreadsheets%20within%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2613147%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWe%20have%20Office%20365%20and%20we%20collaborate%26nbsp%3Bon%20Excel%20workbooks%20at%20the%20same%20time%20with%20co-authoring.%26nbsp%3B%26nbsp%3BTo%20prevent%20accidental%20errors%2C%20I%20am%20trying%20to%20set%20permissions%20to%20different%20users%20to%20access%20different%20spreadsheets%20within%20the%20same%20Excel%20workbook.%20For%20example%2C%20user%20A%20will%20be%20able%20to%20access%20'Sheet1'%20and%20'Sheet2'%20spreadsheets%20but%20not%20'Sheet3'%20spreadsheet.%20User%20B%20will%20be%20able%20to%20access%20'Sheet1'%20and%20'Sheet3'%20spreadsheets%20but%20not%20'Sheet2'.%20Would%20greatly%20appreciate%20any%20advice%20on%20how%20to%20achieve%20this%20function%2C%20thank%20you!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2613147%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

We have Office 365 and we collaborate on Excel workbooks at the same time with co-authoring.  To prevent accidental errors, I am trying to set permissions to different users to access different spreadsheets within the same Excel workbook. For example, user A will be able to access 'Sheet1' and 'Sheet2' spreadsheets but not 'Sheet3' spreadsheet. User B will be able to access 'Sheet1' and 'Sheet3' spreadsheets but not 'Sheet2'. Would greatly appreciate any advice on how to achieve this function, thank you!

0 Replies