Pivot Table Data Disappears

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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