Excel 2003 Pivot Table

Posted on 2009-12-22
Last Modified: 2012-05-08
I have an Excel 2003 Pivot Table.  
my question is this:

How can I determine the source data of this pivot table?  It may be sql sever or a data set on the sheet but I can not see where there is a definitive data source for this pivot table.

Question by:michaelrobertfrench
    LVL 5

    Expert Comment

    click on the pivot table, the click on the options tab, click change source, it should show you . :)
    LVL 5

    Accepted Solution

    I guess I could be more specific, click on the pivot table, then you'll see that the options tab appears, click on it, the on the options tab - click change source, there it will show you database source.


    Author Closing Comment

    thank you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Suggested Solutions

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now