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