[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

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.

thanks,
0
csehz
Asked:
csehz
  • 2
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

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
0
 
jppintoCommented:
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.

jppinto
Capturar.JPG
0
 
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.

cheers,
0
 
csehzAuthor Commented:
You are extra fast, thanks very much found like this
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now