Excel 2010 - Pivot data source

Posted on 2011-04-19
Last Modified: 2012-05-11
Dear Experts,

Can you please advise I assume in a simply question, in Excel 2010 I can not find how to check the source data of a created pivot.

In Excel 2000 this was right click on the table, after selecting Table Wizard, clicking Back and there were that for example from A2:G16.

Question by:csehz
    LVL 50

    Accepted Solution


    click a cell in the pivot table and then use the keyboard shortcut

    Alt-D P to bring up the familiar pivot table wizard, where you can see the pivot source.

    cheers, teylyn
    LVL 33

    Assisted Solution

    When you click on top of your Pivot Table, there is a tab on the menu bar that is Options. You will see a Change Data Source option there.

    LVL 50

    Expert Comment

    Or, select a cell in the pivot table, then click the Options ribbon in the Pivot Table Tools and click Change Data Source.

    LVL 1

    Author Closing Comment

    You are extra fast, thanks very much found like this

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    729 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

    21 Experts available now in Live!

    Get 1:1 Help Now