The expert in this area is Debra Dalgleish and she has information on this
on her site at
http://www.contextures.com/xlPivot12.html

--
Regards

Roger Govier


"GeorgeChe" wrote in message
...
Thanks Roger. Following on from your response, Is it possible to fix data
field so that it can not be de-selected?
Thanks
George

"Roger Govier" wrote:

De-selecting a Data field always removes that field from the Pivot table.
It
assumes you no longer wish to aggregate that data.
Selecting or De-selecting Rows or Columns (or Pages) is merely changing
the
view of the data that has been aggregated.

--
Regards

Roger Govier


"GeorgeChe" wrote in message
...
I have just created a pivot table with two column fields, 1 row field
and
six
data fields. I can select on the column and row fields but when i try
to
select items on
the data field, the unselected items disappear when i go back into drop
down
menu on data field to make another selection. The only way to get it
back
is
to add the field to the data. Is there a way of fixing the fields in
data.

Yours desperately
George