Forum Discussion

yossi2001's avatar
yossi2001
Copper Contributor
Apr 25, 2020

How do I restrict some members to view only excel files within teams, and others to edit?

I have an excel file on Teams that I want to assign some users to view access and some to edit. But I dont see that feature. When I open the file from teams in sharepoint, it allows me to assign users as owner who can edit, and members to view only. but those changes don't cascade back into teams.

How do i limit which members can edit the excel file in teams, and which can only view?

files permissions
  • Andrew Hodges's avatar
    Andrew Hodges
    Bronze Contributor
    Apr 26, 2020

    Hi yossi2001 

     

    This is slightly complicated but bear with me.  If you have Team members but you want to split that into 2 groups Team Members A and Team Members B and assign edit to one and view to the other, it is doable.

     

    The way I think you could do it is change the permissions on the document to view for all Team members - as per Chris's walkthrough. Then create a SharePoint permissions group called "Excel Edit" or similar and add that into the excel file that you want to be editable  and give edit permissions to that group.  Lastly add the users into the "Excel Edit" SharePoint group  that you want to be able to edit the file.

     

    You will then need to manually update "Excel Edit" as and when there are changes to the users that you want to be able to edit files.

  • PeterRising's avatar
    PeterRising
    MVP
    Apr 25, 2020

    yossi2001 

     

    When you open your Teams Document library in SharePoint view,  and look at the doc library permissions, you will see three default groups;

     

    Owners

    Members

    Visitors

     

    Within members, ensure that you only have those users who you wish to be able to edit the files

     

    Within visitors, ensure that you add those who you wish to be able to view only.

     

    Have just tested this and it works as expected.  A user I assigned to the visitors group now sees the flies within the Team as below, and cannot edit the files.

     

Resources