Microsoft Tech Community Live:  Microsoft Teams Edition
November 09, 2021, 08:00 AM - 12:00 PM (PST)

Permissions in Excel in MS Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-2241998%22%20slang%3D%22en-US%22%3EPermissions%20in%20Excel%20in%20MS%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2241998%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20looking%20all%20over%20the%20web%20and%20can't%20seem%20to%20find%20anything%20on%20this%20subject.%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20manage%20who%20can%20view%20and%20edit%20specific%20worksheets%20in%20an%20excel%20file%20in%20MS%20Teams.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20aware%20that%20it%20is%20possible%20to%20manage%20the%20overall%20access%20and%20permission%20for%20a%20document%20or%20folder%2C%20but%20is%20it%20possible%20to%20manage%20permissions%20on%20a%20worksheet%20basis%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20concrete%20issue%3A%3C%2FP%3E%3CP%3EI%20have%20an%20excel%20workbook%20containing%20sensitive%20information%20regarding%20some%20sales%2C%20and%20part%20of%20the%20team%20should%20be%20able%20to%20view%20the%20first%20worksheet%20in%20the%20excel%20file%2C%20and%20only%20a%20few%20members%20should%20be%20able%20to%20view%20and%20edit%20the%20entire%20excel%20workbook.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2241998%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHow-to%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I've been looking all over the web and can't seem to find anything on this subject. 

Is it possible to manage who can view and edit specific worksheets in an excel file in MS Teams. 

I am aware that it is possible to manage the overall access and permission for a document or folder, but is it possible to manage permissions on a worksheet basis? 

 

The concrete issue:

I have an excel workbook containing sensitive information regarding some sales, and part of the team should be able to view the first worksheet in the excel file, and only a few members should be able to view and edit the entire excel workbook. 

1 Reply
That is not a teams issue.
The issue is the data being mixed in excel is not securable.
You need to split it into two different files and secure them appropriately with the right permissions.
Excel has never had or will have a capability to split permissions between sheets,