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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Natalie 1229"
wrote in message
news:Natalie.1229.256qlb_1143222604.7231@excelforu m-nospam.com...

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