Pivot table drill down
Pivot table drill down
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Pivot table drill down

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Denver, Colorado
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    When I create a pivot table, I can double click on a value in the table and Excel creates a new sheet in the workbook with the details behind this data point.

    One of my co-workers cannot do this. Is there a setup item that will enable this feature?

    Thanks.

  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

    On 2002-04-10 13:10, serickson wrote:
    When I create a pivot table, I can double click on a value in the table and Excel creates a new sheet in the workbook with the details behind this data point.

    One of my co-workers cannot do this. Is there a setup item that will enable this feature?

    Thanks.
    Make sure that both "Enable drilldown" and "Save data with table layout" PivotTable options are checked. Right-click on the PivotTable and choose Options... from the popup menu.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Denver, Colorado
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes, both boxes are checked and still no drill down.

    Any other ideas?

    Thanks.

  4. #4
    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

    On 2002-04-10 15:17, serickson wrote:
    Yes, both boxes are checked and still no drill down.

    Any other ideas?

    Thanks.
    Sorry, I must ask... where exactly are they clicking? Is the worksheet protected?

    [ This Message was edited by: Mark W. on 2002-04-10 15:20 ]

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Denver, Colorado
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That's a fair question.

    The workbook/sheet is not protected. She creates them all the time as the rest of us do. All of us are able to drill down by clicking on an amount in the pivot table. A new sheet is created with all of the details.

    I've tried it on her machine without success. (I told her to upgrade to 2000) But if in the meantime we can get it to work for her, that would be great.

    Thanks for your time.

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    okay, so this problem is machine-specific ?

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Denver, Colorado
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    It seems to be happening only on one machine.

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
  •  

 

 
DMCA.com