Disappearing Data Items on Pivot Table -Updated Question

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

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" <[email protected]> wrote in message
news:[email protected]...
>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
>

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" <[email protected]> wrote in message
> news:[email protected]...
> >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
> >
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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
>> >
>>
>>
>>

Thanks again Roger. I now know what to do

"GeorgeChe" wrote:

> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >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
> > >
> >
> >
> >