+ Reply to Thread
Results 1 to 3 of 3

pivot table, identifying data source

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    Rockland Mass.
    MS-Off Ver
    Excel 2007
    Posts
    6

    pivot table, identifying data source

    Hi,
    There doesn't seem to be an obvious way to determine what source data a pivot table is drawing is information from. Can anyone help?
    Gratefully,
    John Quinn

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: pivot table, identifying data source

    Hello,

    to determine what data source a pivot table is using, click any cell in the pivot table. Then, on the Pivot Table Tools ribbon click the "Change Data Source" command. This will highlight the current source for the pivot table.

    cheers, teylyn

  3. #3
    Registered User
    Join Date
    07-05-2012
    Location
    Rockland Mass.
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: pivot table, identifying data source

    Teylyn,
    Thank you very much. Very helpful!
    JQ

+ 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. Replies: 3
    Last Post: 02-27-2012, 08:03 PM
  3. 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
  4. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  5. Replies: 1
    Last Post: 06-20-2010, 04:00 AM

Tags for this Thread

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