Excel Collaboration

%3CLINGO-SUB%20id%3D%22lingo-sub-2261612%22%20slang%3D%22en-US%22%3EExcel%20Collaboration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2261612%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20maybe%20a%20newbie%20question%20but%20I%20need%20to%20find%20an%20answer%20from%20experts.%20One%20of%20my%20users%20is%20looking%20for%20option%20to%20share%20one%20Excel%20document%20among%20few%20people%20but%20wit%20only%20part%20of%20rows%20available%20for%20each%20other.%20So%20i.e.%20user%20X%20should%20be%20abele%20to%20access%20and%20edit%20rows%2010-20%2C%20user%20Y%26nbsp%3B%20-%2021-30%20an%20so%20on.%20The%20owner%2Fauthor%20should%20have%20r%2Fw%20access%20to%20whole%20document.%20Is%20it%20feasible%20at%20all%3F%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EPiotr%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2261612%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello. 

 

This maybe a newbie question but I need to find an answer from experts. One of my users is looking for option to share one Excel document among few people but wit only part of rows available for each other. So i.e. user X should be abele to access and edit rows 10-20, user Y  - 21-30 an so on. The owner/author should have r/w access to whole document. Is it feasible at all?

Cheers

Piotr 

1 Reply

@PiotrOwczarek 

 

Apply different passwords or permissions to separate ranges in workbooks in Excel

Please click on the link for detailed information.

 

A small example - step explanation.

Review tab

Changes

Users are allowed to edit areas

New area

This area relates to the cells: -> entire table, i.e. click on the character to the left of column A and above row 1. Password: Enter twice

Permissions

2 people who are allowed to edit the area (selected with the "Check names" help).

"Allow" permissions

Activate sheet protection including password

Take.

 

I hope you could understand.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.