PivotTable Drop-Down Un-Checked Item Missing
 

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? Im using Excel 2002 with SP3.

Thanks, Peter

PivotTable Drop-Down Un-Checked Item Missing
 

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.

PW1116 wrote:
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? Im using Excel 2002 with SP3.

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