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.

Oh, I found it. Under Insert/Pivot table you can choose Options/
Options for Pivot table. Then go to the tab Show. Here you will
see "Classic Pivot Table Layout (let you drag fields to the grid)
(translated). That's it. :)

Jan T.



"Jan T." skrev i melding
...
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.