Mar 11 2019 08:12 AM
Hi All,
I need some help please.
I am trying to set up a shared/co-authored excel spreadsheet for our company accessible via my OneDrive account.
I have set it all up and added user permissions for a range which works when the file is accessed by myself to test locally but as soon as I try and use excel online to co author the sheet I am told that the sheet is protected and cannot edit the cells. I want all staff to be able to edit this range but even when I set "All Staff" from the list of users in permissions it doesn't seem to work.
I am guessing this is because the permissions are "local" and for some reason anyone even with the link I provide is still being seen as a Guest.
How do I correct this issue?