Sometimes, when I create a PivotTable, and I delete certain row values
in the raw data, I can't get rid of the data values in the drop down
menu of the field. Logically, deleting the raw data should eliminate
that value as a choice for the data values (when you're selecting from
the field drop down menu which rows to show), but the data value still
remains in the fields' drop-down menu. How can I delete it?


--
Natalie 1229
------------------------------------------------------------------------
Natalie 1229's Profile: http://www.excelforum.com/member.php...o&userid=32793
View this thread: http://www.excelforum.com/showthread...hreadid=526176