On Monday, March 4, 2013 3:42:54 AM UTC-8, Alice21 wrote:
Hi



Is there any way that data in a pivot table can be password protected so

that if a user was to select their name from a drop down it would prompt

them for a password before the data is shown?



The reason i ask is because i have alot of personal data in a pivot

table and the users are to only see the data relevant to them when i

send it out. The only way i know how to do this currently is to send

the pivot table out to each individual user ensuring that i firstly

remove data not relevent to them.

As i have over 50+ users, doing this on a monthly basis is quite time

consuming..I would prefer to send ONE pivot table to ALL users but with

security measures in place.



Is this at all possible? :-/

Many Thanks









--

Alice21

Hi Alice21,

By all accounts I have read from the "heavy lifter's" in all the Excel forums where I lurk... Use a password ONLY if all your users will 'play nice'.

Excel is not secure. Password busters are readily available and the only time I ever tried to break a password, (just to see for myself) it took me about 10 minutes or less to do so.

Regards,
Howard