Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Nov 2001
    Location
    Calgary, AB Canada
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reverse Pivot Table ? (XP SP 2 )

    I have been given an Excel spreadsheet and have been asked to do some summarizations on the data in it.

    Just one problem. The data is presented as a pivot table and I can't figure out how to get at the underlying data detail. The pivot table properties say "save data with table", but I can not find the data.

    There are no hidden sheets, but there were a LOT of hidden columns. And I can drill down to see the data, but this is a HUGE spreadsheet to have to drill down every field to get all detail for all rows / columns.

    Any help or direction that can be given would be greatly appreciated.

    tia

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Reverse Pivot Table ? (XP SP 2 )

    Click somewhere in the pivot table.
    Select Data | Pivot table/chart...
    Click < Previous.
    You should see the address of the source data range now.

  3. #3
    Star Lounger
    Join Date
    Nov 2001
    Location
    Calgary, AB Canada
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reverse Pivot Table ? (XP SP 2 )

    The formatting offered managed to get me access.

    Thank you !

Posting Permissions

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