You can't prevent this from happening.
When you remove the check mark for a data field, you're removing the
field from the pivot table.
In other dropdown lists, you're just hiding an item in a pivot field
when you uncheck a box.
When you remove a field, you have to drag it back into the pivot table
from the field list, or in the PivotTable Wizard.
> When I click on the data in the pivot table and deselect a column by
> unchecking it, it disappears from the data list and I can't get it back
> unless I go back to the layout & manually put it back in each time. Does
> anyone know how to prevent this from happening?
>
> Thank you!

Signature
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html