View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jan T.[_3_] Jan T.[_3_] is offline
external usenet poster
 
Posts: 10
Default Different ways to build Pivot table

After upgrading to Excel 2007 the way one are building
the Pivot table seems to be different.

What confuses me, is sometimes I can drag and drop
fields directly on the left hand side of the worksheet. And also
I cannot drag the fields like the old pivot table (prior to 2007)
where a could drag a row field to the top of the sheet changeing
the field to a page field. The only place I can do this now is at the
right hand side in the Field List for Pivot table.

Other times it looks like I can drag the Labels in the Pivot table
and do the pivoting directly in the Pivot table like I use to in
earlier versions of Excel.

How can I control the way I want the Pivot Table to work?

Thanx in advance!

Sincerely Jan T.