Sharing an excel sheet with external users

[Clements365]

Hi, 

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?

[#2 · Accepted solution]

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:

https://docs.microsoft.com/en-us/sharepoint/customize-sharepoint-site-permissions

Or here is a good explanation:

https://sharepointmaven.com/sharepoint-permissions-simplified/

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

Regards, Dave