Home

Permissions On A Shared Excel File

Lukesherwood
New Contributor

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?

1 Reply
Highlighted

Anyone? Any thoughts with this?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies