Excel 2003 Pivot Table - deleted items still show in drop downs

[John]

I have an Excel 2003 Pivot Table. When I delete items in my Database, the
deleted items still show in the drop down list in my pivot table. How can I
delete these old items?
Thanks

 

[Doug Glancy]

John,

By following Debra Dalgleish's excellent advice here:

http://www.contextures.com/xlPivot04.html

hth,

Doug

I have an Excel 2003 Pivot Table. When I delete items in my Database, the
deleted items still show in the drop down list in my pivot table. How can
I delete these old items?
Thanks


__________ Information from ESET NOD32 Antivirus, version of virus
signature database 4445 (20090921) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature database 4445 (20090921) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com