Sharing an excel sheet with external users

Occasional Visitor


I manage a365 domain and a website for my church. I've created a couple of user groups, containing both internal users and guest users.


On this website we publish a link to a schedule in excel with who will play in the band, welcomes guests, etc.

We want the schedule to be accessible only by authenticated users. Some must have read write access, others only read access.


What is the best way to set this up?

1 Reply
best response confirmed by Clements365 (Occasional Visitor)

Hello @Clements365 


you can break the permissions on a site, library or file. You can give write oder read permissions for a defined group.


Here are more information about permissions:


Or here is a good explanation:


Please attention: I recommend you, that you break on higher level like site or library, only in exceptions on file level.


Regards, Dave