How to restrict edit access for Excel files uploaded in a Community Channel?

Question

I have a community channel where I upload a daily Excel report for all community members to use for their day‑to‑day work.

The issue I am facing is that some members are able to directly edit the original Excel file that I uploaded in the channel. Because of this, the data gets changed unintentionally, and it impacts other users who rely on the same file.

What I want is:

• All community members should be able to open and view/download the Excel file
• Only I (or a limited set of users) should have permission to edit the original file
• Other members should not be able to modify the uploaded report directly

Is there any setting, permission option, or best practice available to restrict edit access for files uploaded in a community channel (for example, view‑only access or read‑only sharing)?

Any guidance or recommended approach would be greatly appreciated.

Answer 1

Hi @Vivek Chandrakant Shinde

Regarding your issue, when an Excel file is uploaded to a community channel, it’s stored in the channel’s underlying SharePoint document library. By default, community members are granted Edit permissions on that library, which allows them to open and modify the original file. This is why some users are able to change the data unintentionally. 

At the moment, there isn’t a Teams or Community‑level setting that automatically forces uploaded files to be view‑only. Edit restrictions need to be handled through SharePoint permissions. 

Here are a few steps you can try: 

• Open your Team in the desktop app or web browser. Navigate to the Shared tab at the top of your channel, find your file and click Open in SharePoint. 
• 
• Once SharePoint opens in your browser, click + New > Folder and name it. 
• 
• Right-click the new folder and select Manage Access. 
• 
• Click the three dots (...) in the top corner and select Advanced Settings. 
• 
• In the top ribbon of the new page, click Stop Inheriting Permissions. This "unlinks" this folder from the rest of the Team so you can set unique rules. 
• 
• Check the box next to [Team Name] Members and click Edit User Permissions in the top ribbon. 
• 
• Uncheck Edit and check Read. Click OK. 
• 
• Now you (the Owner) of the channel still have Full Control, but all other community members are now restricted to Read access for anything inside this folder. 
• Once the folder is created with view‑only permissions for members, you can move your existing Excel file into that folder to ensure the same access restrictions are applied. 
• When members open your Excel report now, they will see a "Read-Only" banner at the top.  

Hopefully it will help work with your issue and if you have any other questions or need further assistance, feel free to ask.   

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".     

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

Answer 2

In a Teams community (or team channel) the Excel file inherits its permissions from the underlying SharePoint/OneDrive location. To let everyone view but only a few people edit, configure the file or its folder as read‑only for members in SharePoint.

A practical approach is to use a dedicated read‑only folder for the shared report and restrict edit access there:

1. In Teams, go to the community/channel where the report is shared and open the Files tab.
2. Select Open in SharePoint. This opens the document library that backs the community/channel.
3. In SharePoint, select + New > Folder, name it (for example, Daily Reports), and select Create.
4. For that folder, select the vertical three dots (Show actions) and choose Details.
5. In the Details pane, select Manage access.
6. Under Members, use the dropdown and select Change to view only.
   • This makes all community/channel members “view only” for everything in that folder.
   • As the owner, retain edit rights; if specific users should also edit, grant them explicit edit permission in the same Manage access pane.
7. Upload or move the daily Excel report into this folder. Members will be able to open and download it, but not modify the original file.

Important behavior:

• Any file placed in this folder becomes effectively read‑only for members; only owners (and any explicitly granted editors) can change it.
• If a read‑only file is copied or moved to a different folder that does not have the same restricted permissions, members will be able to edit that new copy.

If instead of a folder‑level setting a single file needs to be locked, use the file’s Manage access options in OneDrive/SharePoint to make it read‑only or adjust sharing so that most users have view permission only. Note that if a sharing link was originally created with edit rights, it cannot be flipped to view; delete that link and create a new view‑only link.

---

References:

• Use folders to create read-only files for students or other team members
• Manage sharing and permissions in OneDrive and SharePoint
• Invite and manage community members in Microsoft Teams Free