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
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! 

0 Replies