Help needed to restrict data users can see in Pivot Table

hvl888

New Member
Joined
May 6, 2018
Messages
6
Hi all,

Hope you are well and thank you in advance for taking your time to read my post.

Not sure if it is at all possible, i have a pivot table with slicers and would like to restrict the information end users can view based on a password I provide them. e.g. the pivot table will contain staff salary information of a number of teams and I only want the team manager to view salary information for his team only using a password i provide him/her. I know its possible to split the information into separate worksheets and only provide them with the data for their Teams, however, there are more than 50 Teams so will be very time consuming to do manually.

Any help or suggestions would be greatly appreciated.

All the best.
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
With confidential data suggest you remove all possibility of access: if the users don't need the flexibility of the pivot table, will pdf copies suffice?
 

hvl888

New Member
Joined
May 6, 2018
Messages
6
Thank you for your reply. i do require the flexibility as there are also regional managers who oversee a number of teams, i want them to be able to view all the teams they oversee or view on a team by team basis so a pivot would be best I believe.

Thanks
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
If only aggregated data is being viewed, then aggregate at as high a level as possible before making the pivot table - otherwise keeping the data confidential will likely be impossible. Passwords are of very limited value, btw.

Or staying with the pdf route, create pdf reports for all possibilities (hopefully a reasonable number & not excessive) & provide the managers with the ones they need.
 

hvl888

New Member
Joined
May 6, 2018
Messages
6
Thank you for your suggestion, I knew my request would be a long shot. Probably best that I look for a different solution.

Regards
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
Different solution = good.

Splitting the data to many (the ~50 teams you mentioned) worksheets may be simple enough?
 

Watch MrExcel Video

Forum statistics

Threads
1,102,363
Messages
5,486,412
Members
407,547
Latest member
Sankarasrinivas

This Week's Hot Topics

Top