Results 1 to 6 of 6

Thread: Help needed to restrict data users can see in Pivot Table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2018
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Help needed to restrict data users can see in Pivot Table

    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.

  2. #2
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    9,154
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Help needed to restrict data users can see in Pivot Table

    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?
    To receive a better answer, put more work into asking the question.


  3. #3
    New Member
    Join Date
    May 2018
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help needed to restrict data users can see in Pivot Table

    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

  4. #4
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    9,154
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Help needed to restrict data users can see in Pivot Table

    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.
    To receive a better answer, put more work into asking the question.


  5. #5
    New Member
    Join Date
    May 2018
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help needed to restrict data users can see in Pivot Table

    Thank you for your suggestion, I knew my request would be a long shot. Probably best that I look for a different solution.

    Regards

  6. #6
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    9,154
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Help needed to restrict data users can see in Pivot Table

    Different solution = good.

    Splitting the data to many (the ~50 teams you mentioned) worksheets may be simple enough?
    To receive a better answer, put more work into asking the question.


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •