+ Reply to Thread
Results 1 to 3 of 3

Return pivot table range...not the data table, the PIVOT TABLE!

  1. #1
    Registered User
    Join Date
    10-26-2004
    Location
    Portland, Oregon
    MS-Off Ver
    Excel in Windows
    Posts
    49

    Question Return pivot table range...not the data table, the PIVOT TABLE!

    What I am looking for is a formula that uses functions intrinsic to Excel -- that is, NO VBA CODE!!!! (which is why I'm posting here and not in Excel Programming) that will return the range of the pivot table. Not the data table that feeds the pivot, I want the actual pivot table. It doesn't matter if it takes a couple of cells to build the formula or if the resultant formula is huge. Is this possible?
    ~Toby

  2. #2
    Registered User
    Join Date
    10-26-2004
    Location
    Portland, Oregon
    MS-Off Ver
    Excel in Windows
    Posts
    49
    Nice to know I still have the ability to stump everyone! :-D

  3. #3
    Forum Contributor
    Join Date
    02-25-2008
    Location
    Windsor, ON Canada
    MS-Off Ver
    Excel 2007, 2003
    Posts
    119
    When I encounter this issue, I usually just copy/paste the pivot table data to a new worksheet and pull values from that.

    It's probably not the 'smartest' fix, but it works.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1