Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Nov 2002
    Location
    London, Gtr London, England
    Posts
    496
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Pivot Table Mutiple Consolidation in 2010

    Dear Loungers,

    Where can I specify multiple data sources for my pivot table in 2010?

    liz

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    Perhaps this may help. It comes from the MS Office site. IN 2003 The Wizard does show the consoliation option.

    Important In Microsoft Excel 2010, the PivotTable and PivotChart Wizard that was available in earlier versions of Excel has been replaced with PivotTable and PivotChart commands on the Insert tab in the Tables group. The PivotTable and PivotChart Wizard is still available, and you can use it as needed by adding it to the Quick Access Toolbar, or by pressing ALT, D, P to start it.

    TD

  3. #3
    4 Star Lounger
    Join Date
    Nov 2002
    Location
    London, Gtr London, England
    Posts
    496
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Dear TD,

    Thank you, that much I know but I can't find how to specify multiple sources???

    UPDATE: I cuold not get the wizard up and that was confusing things, I got some "helpful" MS mmessage about shortcut keys. However I now have maged to do this so I can use the wizard and all should be fine

    Thank you

    liz
    Last edited by lizat; 2011-12-19 at 06:44.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •