Home

Permissions in Sharepoint/Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-358400%22%20slang%3D%22en-US%22%3EPermissions%20in%20Sharepoint%2FExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358400%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%26nbsp%3B%3C%2FP%3E%3CP%3EAttempting%20to%20set%20up%20an%20excel%20file%20in%20Sharepoint%20that%20restricts%20viewers%20from%20editing%2Fsyncing%2C%20but%20does%20allow%20them%20to%20download%20a%20local%20copy%20and%20make%20edits%20on%20their%20computers.%20The%20idea%20behind%20this%20is%20that%20while%20everyone%20can%20view%20the%20most%20current%20version%2C%20they%20have%20to%20email%20me%20directly%20to%20propose%20any%20changes%20and%20can't%20just%20make%20them%20themselves.%20I've%20tried%20protecting%20cells%2C%20restricting%20permissions%20in%20the%20excel%2C%20and%20restricting%20permission%20in%20Sharepoint%2C%20but%20none%20of%20these%20has%20been%20able%20to%20get%20the%20right%20balance%20of%20restricted%20access.%20Part%20of%20the%20issue%20is%20that%20many%20people%20have%20access%20to%20the%20Sharepoint%20folder%20this%20excel%20file%20is%20sitting%20in%2C%20so%20creating%20a%20read-only%20link%20to%20the%20excel%20file%20doesn't%20work.%20Any%20advice%20is%20much%20appreciated.%20Thanks!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-358400%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
rtoney
Occasional Visitor

Greetings, 

Attempting to set up an excel file in Sharepoint that restricts viewers from editing/syncing, but does allow them to download a local copy and make edits on their computers. The idea behind this is that while everyone can view the most current version, they have to email me directly to propose any changes and can't just make them themselves. I've tried protecting cells, restricting permissions in the excel, and restricting permission in Sharepoint, but none of these has been able to get the right balance of restricted access. Part of the issue is that many people have access to the Sharepoint folder this excel file is sitting in, so creating a read-only link to the excel file doesn't work. Any advice is much appreciated. Thanks! 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
7 Replies