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

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?