We help IT Professionals succeed at work.

Private Excel Sheets

Bob Schneider
Bob Schneider asked
on
Is there a way to have a single excel workbook shared with multiple users where each user can only SEE a single sheet after supplying login credentials?  I know you can prevent editing in this manner but I want to prevent viewing as well.

I am trying to create a simple password keeper for a small organization so that the users can stop using sticky notes stuck to their monitor for this purpose.  I am open to other suggestions but they have to be free and easy to use.

Thanks so much!
Comment
Watch Question

View Solution Only

Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Anything you hide in Excel can be seen by people who know a few tricks, so I don't believe Excel is appropriate as a password manager. I believe there are free ones on the web..
Social distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
From the web.
2020-02-20_09-12-00.png
Bob SchneiderCo-Owner

Author

Commented:
I use LastPass and I love it but I have been unsuccessful in getting our staff to use it.  Plus, it seems to intentionally create some gray area between "Free" and "Trial".  I may talk with Admin about using pressing this on the staff.  Thanks!
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You're welcome. You might want to try a couple of others and then present the options and your opinions to the administration. You could also write an article for EE:)