Teams Group Excel Document

Zubke, Jackie 1 Reputation point
2022-03-09T18:20:57.847+00:00

Hi,

Is there anyway to create view only access to Excel documents in a teams group? Where there is no option for someone to edit the document?

Thanks

Microsoft Office Online Server
Microsoft Office Online Server
Microsoft on-premises server product that runs Office Online. Previously known as Office Web Apps Server.
586 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Hua-MSFT 27,526 Reputation points
    2022-03-10T05:09:31.46+00:00

    Hi @Zubke, Jackie

    1 From an Excel perspective, you can add the modify password on Excel worksheets, then send it to Teams group.

    • When you save this workbook, please click the Tools option > Geneal Options.
      181617-capture23.jpg
    • Add the modify password to save this file.
      181697-capture24.jpg
    • If other users open this file and do not have this password, they can click "Read Only" to open it.
      181649-capture25.jpg

    2 From OneDrive perspective, you can upload this wrokbook to OneDrive cloud and create a shared link, then copy the link to Teams group.
    But you need to set other users have only view permissions on this shared file.
    181698-capture26.jpg
    Other users do not be allowed to edit this file.
    181706-capture27.jpg

    Hope the information could be helpful.


    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.


    0 comments No comments