[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 250
  • Last Modified:

Can we give permissions to the rows to different users

Hi,

I need to circular a excel to say 500 users.For updating there details.
Is it possible to give permissions to each row so that no other user can edit other rows or damage them.
Regards
Sharath
0
bsharath
Asked:
bsharath
  • 3
  • 2
  • 2
1 Solution
 
Rory ArchibaldCommented:
Yes - Tools->Protection->Allow users to edit ranges.
Might take a while to set up though!
Regards,
Rory
0
 
zoofanCommented:
Dont think you can do row permissions.  But you could do a password protected sheet for each.


zf
0
 
cipher007Commented:
Yes, this can be done, however you and the other users who need editing of the file needs to be on a domain. If they are on a domain then you can give access to any cells on the sheet to any users.

The users will need to be logged in to the domain in order to edit the cells (which you have given access to).

http://office.microsoft.com/en-us/excel/HA100968371033.aspx#UnlockCells

hope this helps,
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
zoofanCommented:
Very sweet,  sadly in 07 and above but still very nice find cipher

zf
0
 
Rory ArchibaldCommented:
No, you can do that in 2002, 2003 and 2007. [There isn't anything above 2007 yet! :) ]
Regards,
Rory
0
 
cipher007Commented:
zoofan, I'm sure that can be done using 2003, atleast,  because I  used to do it on our network using MS Excel 2003 :-)

0
 
zoofanCommented:
Cool,  thanks.

zf
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now