+ Reply to Thread
Results 1 to 4 of 4

Original Source of Pivot Table Data

  1. #1
    Registered User
    Join Date
    09-15-2006
    Posts
    15

    Original Source of Pivot Table Data

    Hello all,

    I have a large collection of pivot tables created some time ago and undocumented/unreferenced. Does anyone know if there is any way to find out what the data source for an already created Pivot Table is? I've been fiddling around with options and properties, right-clicking, even went into help and searched on the web, but no luck so far.

    Thank you in advance!

    Alex

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,316
    Hi,

    If you right click the pivot table, go to "wizard", and then press "back" it will show you the source data
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325
    Quote Originally Posted by akexcel
    Hello all,

    I have a large collection of pivot tables created some time ago and undocumented/unreferenced. Does anyone know if there is any way to find out what the data source for an already created Pivot Table is? I've been fiddling around with options and properties, right-clicking, even went into help and searched on the web, but no luck so far.

    Thank you in advance!

    Alex
    Right-click your PT, select PT wizard and click the " Back" button. You will then be able to see the data source

    Cheers

  4. #4
    Registered User
    Join Date
    09-15-2006
    Posts
    15
    Thanks a lot!

+ 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