Sharing of excel worksheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2091743%22%20slang%3D%22en-US%22%3ESharing%20of%20excel%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2091743%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20all%2C%3C%2FP%3E%3CP%3EI%20have%20set%20up%20a%20database%20in%20excel.%20Now%20I%20want%20to%20share%20that%20database%20and%20want%20everyone%20else%20to%20have%20specific%20permissions%2C%20which%20are%3A%3C%2FP%3E%3CP%3ESorting%20and%20filtering%20the%20entries%20in%20certain%20columns%3C%2FP%3E%3CP%3EAdding%20comments%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20should%20explicitely%20be%20not%20allowed%20to%3A%3C%2FP%3E%3CP%3EEdit%20any%20entries%20in%20cells%3C%2FP%3E%3CP%3Edelete%20cells%3C%2FP%3E%3CP%3Eadd%20cells%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20some%20things%3A%3C%2FP%3E%3CP%3EIf%20i%20share%20the%20worksheet%20as%20read%20only%2C%20the%20filtering%20option%20is%20fine%20but%20when%20one%20tries%20to%20sort%20columns%20it%20says%20that%20the%20content%20is%20protected.%3C%2FP%3E%3CP%3EIf%20I%20do%20protect%20worksheet%20but%20in%20permissions%20tick%20%22sort%22%20and%20%22AutoFilter%22%20it%20is%20basically%20the%20same%2C%20filter%20works%20sort%20not%3C%2FP%3E%3CP%3EIf%20i%20try%20to%20do%20it%20with%20edit%20ranges%2C%20and%20tick%20explicitely%20only%20%22select%20cells%22%20%22sort%22%20and%20%22AutoFilter%22%20they%20can%20somehow%20also%20edit%20the%20content%20of%20the%20individual%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20i%20keep%20this%20database%20regularly%20updated%20so%20to%20share%20it%20as%20read%20only%20and%20telling%20the%20others%20to%20download%20it%20and%20then%20sort%20and%20filter%20it%20is%20also%20no%20option.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20convinient%20way%20to%20get%20this%20working%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20the%20best%3C%2FP%3E%3CP%3ETom%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2091743%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hey all,

I have set up a database in excel. Now I want to share that database and want everyone else to have specific permissions, which are:

Sorting and filtering the entries in certain columns

Adding comments

 

They should explicitely be not allowed to:

Edit any entries in cells

delete cells

add cells

 

I have tried some things:

If i share the worksheet as read only, the filtering option is fine but when one tries to sort columns it says that the content is protected.

If I do protect worksheet but in permissions tick "sort" and "AutoFilter" it is basically the same, filter works sort not

If i try to do it with edit ranges, and tick explicitely only "select cells" "sort" and "AutoFilter" they can somehow also edit the content of the individual cells.

 

I also i keep this database regularly updated so to share it as read only and telling the others to download it and then sort and filter it is also no option.

 

Is there a convinient way to get this working?

 

All the best

Tom

0 Replies