Pivot Table Data Disappears

T

tbrant07

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!
 
D

Debra Dalgleish

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.
 
Top