Row Labels all go in one column - 2007 version

[Motox]

Hi Forum,

We have been using Excel 2003 and create Pivot Tables from a report that we recieve each week. We then use the first three columns in the Pivot Table for VLookups.

Now we have Excel 2007 and when we create the Pivot Table the 3 fields that we use for Row Labels all end up together in one column. I can't use the result for VLookups anymore.

How can I have the 3 fields in Row Labels appear in 3 separate columns like in 2003?


Thanks very much

Dave

[Andy Pope]

Try the Outline layout via the Layout options in the Design tab.