PivotTable Drop-Down Un-Checked Item Missing

[Guest]

When a PivotTable field list (drop-down item is not checked in column data
for “slicing†and “dicing,†the item fails to return to the column drop-down
list. The item must again be added to the PivotTable data field. This
happens when the data and column headings are the same. Is there a
work-around or a macro? I’m using Excel 2002 with SP3.

Thanks, Peter

 

[Debra Dalgleish]

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.

There's no workaround -- when you remove a field, you have to drag it
back into the pivot table from the field list, or in the PivotTable Wizard.

You could record a macro as you add the field to the data area, and run
the macro as required.