Good morning,

version : Excel 2007 SP 1 MSO

I want only column fields (no problem) and fields in the value area.
when dragging a second field to the values area, automatically a "Values
field" is added (to the column label area, I drag it then to the row field
area)
so far so good

then I want, by selecting the check box of the fields, add other fields to
the value area. sometimes they are adde to the row area (I don't want that,
I want them in the value area)

do you know any vba code to move them "in bulk" or better (because moving
them in bulk will force me to move every field up or down ...) find a way
that by clicking the check box of the fields, they are moved to the area I
want (defined in advance).

THANKS FOR YOUR HELP !!!


"Roger Govier" wrote:

Hi

I am not fully understanding your problem.
Which version of Excel are you using?

You can only move a filed at a time, but to any area of the PT.
You cannot move all "in Bulk" (without using some VBA code).
You cannot have all fields in the data area, there has to be at least a row
or a column field.

--
Regards
Roger Govier

"Raf Rollier" wrote in message
...
I select a check box for a field in order to have it moved to the values
area
of my pivot table;
however the field is numeric, sometimes it is moved by default to the row
label area
(sometimes it is moved by default to the values area for the same pivot
table : I can not find what the trigger is)

how can I avoid this or how can I drag "in bulk" all fields from the row
label to the values area ?
thanks !