Grant the different access to share point users

%3CLINGO-SUB%20id%3D%22lingo-sub-878219%22%20slang%3D%22en-US%22%3EGrant%20the%20different%20access%20to%20share%20point%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-878219%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20know%20the%20way%20how%20to%20grant%20the%20different%20access%20to%20share%20point%20users.%3C%2FP%3E%3CP%3ESince%20we%20hope%20only%20admin%20users%20have%20the%20access%20to%20%E2%80%9C%3CSPAN%3EExport%20to%20excel%3C%2FSPAN%3E%E2%80%9D%3CSPAN%3E%20function%20of%20share%20point.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20other%20user%20could%20not%20use%20%E2%80%9C%3CSPAN%3EExport%20to%20excel%3C%2FSPAN%3E%E2%80%9D%20%3CSPAN%3Efunction.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3EJo%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-878219%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-878565%22%20slang%3D%22en-US%22%3ERe%3A%20Grant%20the%20different%20access%20to%20share%20point%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-878565%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F399400%22%20target%3D%22_blank%22%3E%40Tiffany_Jo%3C%2FA%3E%26nbsp%3BIn%20general%20SharePoint%20has%20three%20level%20of%20access%20Admin%2C%20Contributor%20%2FEditor%20and%20Readers%2C%20Export%20to%20excel%20functionality%20only%20allows%20data%20to%20be%20downloaded%20and%20not%20edited%20hence%20all%20users%20have%20access%20that%20is%20least%20level%20Readers%20as%20well.%3C%2FP%3E%3CP%3EThere%20is%20no%20standard%20way%20of%20not%20allowing%20Export%20to%20excel%20to%20other%20users%20except%20Admin.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi 

 

I would like to know the way how to grant the different access to share point users.

Since we hope only admin users have the access to “Export to excel function of share point.

The other user could not use “Export to excelfunction.

 

Thank you.

Jo

1 Reply

@Tiffany_Jo In general SharePoint has three level of access Admin, Contributor /Editor and Readers, Export to excel functionality only allows data to be downloaded and not edited hence all users have access that is least level Readers as well.

There is no standard way of not allowing Export to excel to other users except Admin.