Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Toowoomba, Queensland, Australia
    Posts
    112
    Thanks
    0
    Thanked 0 Times in 0 Posts

    GETPIVOTDATA (EXCEL 2002/XP)

    At times, I want to use data from a pivot table to do on the fly calcs etc., but it seems that whenever I try to reference a cell within a pivot table I automatically get the GETPIVOTDATA function. Is there any way to change this so that I get the standard cell reference.

    Thanks

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: GETPIVOTDATA (EXCEL 2002/XP)

    If you click on the cell while editting - you will get the GETPIVOTDATA
    To just get the reference then type it directly e.g. =D5 or whatever

  3. #3
    New Lounger
    Join Date
    Feb 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: GETPIVOTDATA (EXCEL 2002/XP)

    Is this new with the XP version? I have a user with the same complaint. I tested this in Excel '97 and the point and click method did work, you didn't receive the "GETPIVOTDATA" function. I couldn't find anything in the HELP, nor a couple of manuals that I have.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: GETPIVOTDATA (EXCEL 2002/XP)

    Took me nearly 2 years to run into the same problem. And what a simple solution. Doh!!!
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  5. #5
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: GETPIVOTDATA (EXCEL 2002/XP)

    We too have recently upgraded to the newer version of Excel... I have experienced the same issue stated in the original question... as you have already suggested, my solution was to just type in the formula, however I find that to be a bit tedious at times as the formulas can be quite long... any chance there's a faster way????

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: GETPIVOTDATA (EXCEL 2002/XP)

    LJM,

    Is this what you want to do?

    http://www.contextures.com/xlPivot06.html

    BAN

  7. #7
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: GETPIVOTDATA (EXCEL 2002/XP)

    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> That is exactly what I wanted... so glad there was an option... thanks so much for your help!!

Posting Permissions

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