mulitple worksheets - pivot table

[setmoa]

Hello

I'm new to pivot tables and i'm currently learning the advanced excel 2007 dvd.

I would like to do a pivot table with data from mulitple worksheets, is this possible?

thanks

Ally

 

[GlennUK]

Have a read of this first, and see if it's of any use:

http://www.contextures.com/xlPivot08.html

 

[jim may]

It appears the PT Wizard has changed between Ver 2003 and Ver 2007, or
am I missing something here. I just loaded 2007 over the weekend, so this
is going to be interesting (picking up on the changes between versions).

 

[setmoa]

Yes i'm afraid it seems that there is no longer a pivot table wizard in 2007.

Anybody got any other ideas of how you can do this with the new version?

 

[GlennUK]

It's a hidden key combination ... ALT-D-P