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

yours desparately
George

see reply to your later posting

--
Regards

Roger Govier


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

yours desparately
George