Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Determine Pivot Table Source Data (2002)

    I inherited a spreadsheet with a pivot table on it. I would like to be able to determine the rows and columns that are the source data for the pivot table. For example, the pivot points back to a detail sheet and I would like to know what rows and columns were selected for the pivot.

    Is this possible?

    Thanks.

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

    Re: Determine Pivot Table Source Data (2002)

    Click in the pivot table (any cell will do)
    Select Pivot Table | Wizard... from the Pivot Table toolbar.
    Click <Previous in the dialog that appears.
    You should now see the source range.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Determine Pivot Table Source Data (2002)

    Perfect.

    Thanks.

Posting Permissions

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