Excel 2010 - Pivot data source

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.

csehzIT consultantAsked:
Who is Participating?
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:

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
jppintoConnect With a Mentor Commented:
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.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Or, select a cell in the pivot table, then click the Options ribbon in the Pivot Table Tools and click Change Data Source.

csehzIT consultantAuthor Commented:
You are extra fast, thanks very much found like this
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.