Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data values WON'T DELETE in PivotTable drop-downs
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data values WON'T DELETE in PivotTable drop-downs
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data values WON'T DELETE in PivotTable drop-downs
You are marvelous! I can't tell you how grateful I am for your willingness to share your PivotTable acumen. How did you become so astute? Is that book highly recommended (by you)? -- 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data values WON'T DELETE in PivotTable drop-downs
Debra is pretty much the Queen of the pivot table, and if there was a Pivot
table question she couldn't answer, then I'd be tempted to think it couldn't be done. :-) Regards Ken..................... "Natalie 1229" wrote in message news:Natalie.1229.25cgdn_1143489302.0616@excelforu m-nospam.com... You are marvelous! I can't tell you how grateful I am for your willingness to share your PivotTable acumen. How did you become so astute? Is that book highly recommended (by you)? -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete duplicate record but only determine 1 column data | Excel Worksheet Functions | |||
Drop downs in Data Form | Excel Discussion (Misc queries) | |||
How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Macro data selection line delete | Excel Discussion (Misc queries) |