Permissions On A Shared Excel File

%3CLINGO-SUB%20id%3D%22lingo-sub-364233%22%20slang%3D%22en-US%22%3EPermissions%20On%20A%20Shared%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364233%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20some%20help%20please.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20set%20up%20a%20shared%2Fco-authored%20excel%20spreadsheet%20for%20our%20company%20accessible%20via%20my%20OneDrive%20account.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20set%20it%20all%20up%20and%20added%20user%20permissions%20for%20a%20range%20which%20works%20when%20the%20file%20is%20accessed%20by%20myself%20to%20test%20locally%20but%20as%20soon%20as%20I%20try%20and%20use%20excel%20online%20to%20co%20author%20the%20sheet%20I%20am%20told%20that%20the%20sheet%20is%20protected%20and%20cannot%20edit%20the%20cells.%20I%20want%20all%20staff%20to%20be%20able%20to%20edit%20this%20range%20but%20even%20when%20I%20set%20%22All%20Staff%22%20from%20the%20list%20of%20users%20in%20permissions%20it%20doesn't%20seem%20to%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20guessing%20this%20is%20because%20the%20permissions%20are%20%22local%22%20and%20for%20some%20reason%20anyone%20even%20with%20the%20link%20I%20provide%20is%20still%20being%20seen%20as%20a%20Guest.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20correct%20this%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-364233%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-364818%22%20slang%3D%22en-US%22%3ERe%3A%20Permissions%20On%20A%20Shared%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364818%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%3F%20Any%20thoughts%20with%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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?