Sunday, September 18, 2011

Pivot Tables ( Consolidating multiple sheets)

Pivot Tables can be tricky to new users but probably THE MOST POWERFUL thing in Excel.
This week I was stumped on how to consolidate using Excel 2010 when creating a Pivot.
When you go to Insert Pivot, there are now NO OPTIONS to get your data from a set of multiple worksheets. So unless you consolidate first it seemed a no go .

However upon researching it the only way to get the Excel 2003 options for Pivot Wizard is to use a magic shortcut :

ALT D then P, then you get the typical Pivot Table Wizard screen with mutiple sheet options, HEY PRESTO !

Insert Pivot only gives you these options in 2007 and 2010:

thanks !


Testing out the NEW Blogger Interface and it seems very strange but useful !!

Search This Blog

Desktop Applications Training Blog

Jamie Johnson
JJSurf IT Training Ltd
There was an error in this gadget
There was an error in this gadget

The Daily Puppy