Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Pivot Table Help Needed - Restricting the use of specific Pa

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Tulsa, OK
    Posts
    319
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way to restrict the use of a specific pivot table field without restricting others?

    Example:
    Pivot Table 1 has page fields:
    EMPLOYEE NAME
    CLIENT NAME

    Data fields:
    PRODUCT SOLD
    QUANTITY
    SALES AMOUNT
    COMMISSION

    I want to be able to e-mail the Pivot/Worksheet as an attachment to the specific employee, but only allow them to see their own information and not that of their fellow employees.

    I can password-protect the sheet, but this disables all pivoting to the report. I only want to turn off the pivoting capability the EMPLOYEE NAME Page Field, leaving the other page filds and data fields free to pivot. Is this possible?

    Any help would be great!
    - Jim

    (Office 365)


    "Working on mysteries without any clues..."

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    PivotTables "see" all of the source data, and "remember" all field items that existed since its creation.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Tulsa, OK
    Posts
    319
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    So, I guess this means it isn't possible? Fogive me, I am still a novice when it comes to Pivot Tables and their capabilities.
    - Jim

    (Office 365)


    "Working on mysteries without any clues..."

Some videos you may like

User Tag List

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
  •