Pivot table data dissappears

[Ted]

I am using data from an Excel sheet (Excel2003 sp1) that is on the same page
as my pivot table. It works exactly as I want it to whenever I click on
different categories from the dropdown boxes attached to "page," "column" or
"row." It also works when I use the "data" dropdown box; that is, I
eliminate some of the categories of data BUT when I click on the "data"
dropdown arrow again, the categories that I deselected are no longer shown
and I must drag the missing data category from the feild selection box to the
pivot table in order to view it again.

Is there any way to tell Excel to retain all categories of data that I
originally selected, so my user does not have to alter the setup (and risk
gumming up the whole table by inadvertant alterations)?

Thank for any help.

 

[Debra Dalgleish]

If you uncheck an item in the data dropdown list, it's removed from the
pivot table. There's no way to retain it in the data field list.

To get it back, you can drag it in from the field list.