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
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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 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