Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Pivot Tables » Retrieve underlying data of an Excel pivot table using vba

Retrieve underlying data of an Excel pivot table using vba

Previous | Next
Latest post Mon, Nov 10 2008 3:37 PM by Nick Hodge. 1 replies.

  • Sun, Nov 9 2008 8:10 AM

    • kaak
    • Top 25 Contributor
    • Joined on Fri, Jan 18 2008
    • Edam, Netherlands
    • Posts 34
    • Points 613

    Retrieve underlying data of an Excel pivot table using vba

    Reply |Contact

    I have a workbook with one sheet and a pivot table. The data is stored in a pivotcache.

    Is there a way to retrieve the underlying data of the pivot table without selecting a data field and using Selection.ShowDetail = True. Or can a display the records from the pivotcache from vba...?

    thnx
    Filed under:
    • Post Points: 21

  • Mon, Nov 10 2008 3:37 PM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 336
    • Points 5,771
    • MVP

    Re: Retrieve underlying data of an Excel pivot table using vba

    Reply |Contact |Mark as Answer

    Kaak

    I don't know of a way, maybe if you elaborated what you are trying to do, maybe there is a better way?

    Nick

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.