Is it possible to restrict users from editing an excel file online?

%3CLINGO-SUB%20id%3D%22lingo-sub-86930%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20to%20restrict%20users%20from%20editing%20an%20excel%20file%20online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-86930%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20this%20sharepoint%20page%20using%20excel%20web%20access%20that%20displays%20the%20content%20of%20the%20excel%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20find%20a%20way%20to%20show%20an%20excel%20sheet%20to%20a%20set%20of%20users%2C%20but%20these%20users%20can%20only%20download%20a%20copy.%20THey%20can%20see%20the%20content%20displayed%20in%20the%20excel%20web%20access%20webpart%2C%20but%20that%20is%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20should%20not%20be%20able%20to%20edit%20the%20file%20using%20Excel%20Online%20or%20simply%20editing%20in%20Excel%20application%2C%20otherwise%20that%20would%20ruin%20content%20of%20this%20excel%20file.%20(Trying%20to%20keep%20it%20as%20the%20original%20file).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20should%2C%20however%2C%20be%20able%20to%20download%20a%20copy%20of%20this%20excel%20file.%20I%20have%20this%20excel%20file%20in%20a%20hidden%20library%20from%20the%20user.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESadly%20the%20Excel%20Web%20Access%20webpart%20has%20nice%20option%20that%20prevents%20editing%2C%20but%20also%20unable%20to%20download%20a%20copy%20or%20a%20snapshot.%20(I%20feel%20this%20should%20be%20all%20separate)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20a%20user%20clicks%20on%20the%20title%20URL%20link%2C%20it%20will%20take%20them%20to%20the%20excel%20online%20of%20the%20file%20and%20there%20they%20can%20edit%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20question%20is...is%20it%20possible%20to%20restrict%20the%20editing%20of%20this%20file%20online%20and%20offline%20and%20be%20able%20to%20only%20just%20download%20a%20copy%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20workaround%20to%20this%20so%20far%20is%20to%20just%20disable%20the%20download%20in%20the%20webpart%20and%20perhaps%20create%20a%20%22Download%20Link%22...%20but%20I%20don't%20know%20how%20useful%20is%20that%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20input%20is%20greatly%20appreciated!%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-86930%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-86946%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20restrict%20users%20from%20editing%20an%20excel%20file%20online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-86946%22%20slang%3D%22en-US%22%3EIf%20you%20want%20those%20users%20to%20edit%20the%20file%2C%20your%20only%20choice%20is%20just%20to%20give%20then%20%22view%20only%22%20permissions%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-917474%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20restrict%20users%20from%20editing%20an%20excel%20file%20online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-917474%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53673%22%20target%3D%22_blank%22%3E%40Jonathan%20Nunez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi!%20Did%20you%20find%20out%20if%20it's%20possible%20to%20restrict%20user%20from%20editing%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Greetings,

 

I have this sharepoint page using excel web access that displays the content of the excel file.

 

I'm trying to find a way to show an excel sheet to a set of users, but these users can only download a copy. THey can see the content displayed in the excel web access webpart, but that is it. 

 

They should not be able to edit the file using Excel Online or simply editing in Excel application, otherwise that would ruin content of this excel file. (Trying to keep it as the original file).

 

They should, however, be able to download a copy of this excel file. I have this excel file in a hidden library from the user. 

 

Sadly the Excel Web Access webpart has nice option that prevents editing, but also unable to download a copy or a snapshot. (I feel this should be all separate)

 

If a user clicks on the title URL link, it will take them to the excel online of the file and there they can edit it.

 

My question is...is it possible to restrict the editing of this file online and offline and be able to only just download a copy? 

 

My workaround to this so far is to just disable the download in the webpart and perhaps create a "Download Link"... but I don't know how useful is that 

 

Any input is greatly appreciated! Thanks!

2 Replies
Highlighted
If you want those users to edit the file, your only choice is just to give then "view only" permissions
Highlighted

@Jonathan Nunez 

Hi! Did you find out if it's possible to restrict user from editing?