Different ways to build Pivot table


J

Jan T.

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.
 
Ad

Advertisements

J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top