Pivot table confusion in excel 2007

  VNAM75 15:56 02 Sep 2008
Locked

I've just installed excel 2007 (from 2003)and trying to create a pivot table. I have 4 fields in the Row area and instead of them being shown horizontally in cells A3:D3, they are all under column A and I have to drill down to see the data. The data is there but you don't know which field they relate to.
How can get it show the field names in the old pivot table format?

  VoG II 17:10 02 Sep 2008

This may help click here

  VNAM75 19:30 02 Sep 2008

Thanks VoG, I'd worked it out earlier but your link has the answer too and other useful information.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

Why this awful City of Los Angeles job ad for a graphic designer is actually brilliant

iMac Pro review

Les meilleures prises CPL (2018)