XL2007 Pivot Tables 1

[MeGustaXL]

I decided to try Skip's FAQ:
faq68-5287

I reproduced the example table, went to Insert, Tables, Pivot Table, and... it just makes a blank, plain vanilla PT, with a Field List on the right. No wizard, no options for multiple consolidation ranges, nada.

How can I make it work properly, given that it's company policy to use Office 2007 so going back to 2003 is not an option?

Chris

So you ride yourselves over the fields,
and you make all your animal deals,
and your wise men don't know how it feels...

Ian Anderson

 

[SkipVought]

Start with alt+D P

and go from there.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MeGustaXL]

Gee Skip, you should do this for a living Man! I never thought of that. "Thank you" just doesn't cover it.

 

[SkipVought]

You're welcome!

And have a GREAT, Prince Spaghetti Day!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}