+ Reply to Thread
Results 1 to 8 of 8

Pivot Table (extracted data from pivot, in source formatting)

  1. #1
    Registered User
    Join Date
    12-04-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Pivot Table (extracted data from pivot, in source formatting)

    Hi all,

    I've a question,

    could you all Excel Experts help me by solving below mentioned prob related to Pivot Table...

    To make a Pivot table we need a raw data....

    when we double click or do show details then prob starts....

    we generally get required data by just double clicking on that number....
    but its comes without source formatting...

    like if there are hyperlink in the source data then it should come under extracted data from pivot table....


    below are some screen shorts for the same...

    Raw Data >>source file.png

    Pivot Table >>Pivot table.png

    Extracted Data >>extracted Data.png


    Excel >>


    please help me out.....

    Regards,
    Sumit Sharma
    Attached Files Attached Files
    Last edited by nsumitg; 12-06-2013 at 06:19 AM. Reason: Excel file is attached

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Pivot Table (Source

    Can you attach a workbook instead of pictures, please.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    12-04-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Pivot Table (Source

    Excel is attached... please have a look...

  4. #4
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Pivot Table (extracted data from pivot, in source formatting)

    Okay, I understand you now.

    It is not possible to retrieve source formatting (including hyperlinks) by drilling into a pivot table - the pivot table looks at data values only, not formats.

  5. #5
    Registered User
    Join Date
    12-04-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Pivot Table (extracted data from pivot, in source formatting)

    thanks for your reply....

    but can we do that through VBA or macro...

  6. #6
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Pivot Table (extracted data from pivot, in source formatting)

    Quote Originally Posted by nsumitg View Post
    thanks for your reply....

    but can we do that through VBA or macro...
    Probably. Would it not be easier to simply filter your source data, though?

  7. #7
    Registered User
    Join Date
    12-04-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Pivot Table (extracted data from pivot, in source formatting)

    its an assignment... if it is possible then i've to do that....

  8. #8
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Pivot Table (extracted data from pivot, in source formatting)

    Quote Originally Posted by nsumitg View Post
    its an assignment... if it is possible then i've to do that....
    Okay, so you want to loop through the results of drilled down data, and for each row, find the matching values in the source data, identify the hyperlink address, and apply that to your extracted data.

    I'm sure, as it's an assignment, you don't want me to write it all for you, do you?!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 08-14-2013, 06:31 AM
  2. Pivot table - change data source to another pivot table in 2010
    By thesecretsanta in forum Excel General
    Replies: 4
    Last Post: 04-13-2011, 12:54 PM
  3. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  4. Replies: 1
    Last Post: 06-20-2010, 04:00 AM
  5. [SOLVED] Create Pivot Table: Cannot Open Pivot Table Source File
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-05-2010, 05:11 AM

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