Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - I can't delete unused values in selection drop-downs
I have a pivot table by that I update every month, by refreshing the query to
append the new data. It has data by customer and period, type of work, etc., with values for Parts, Labor, Tax, etc. I was asked to strip out data to leave only information to send to a single customer. I have removed all data from the source range except for that belonging to that customer, but in the pivot table selection box for customer, all of the other customers' names still appear. I have already resaved the entire pivot table and reopened it, with the "refresh on open" parameter checked, but they do not disappear. How do I get unused values to drop from the list? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - I can't delete unused values in selection drop-downs
Check out this link...
http://www.contextures.com/xlPivot04.html -- HTH... Jim Thomlinson "lireland" wrote: I have a pivot table by that I update every month, by refreshing the query to append the new data. It has data by customer and period, type of work, etc., with values for Parts, Labor, Tax, etc. I was asked to strip out data to leave only information to send to a single customer. I have removed all data from the source range except for that belonging to that customer, but in the pivot table selection box for customer, all of the other customers' names still appear. I have already resaved the entire pivot table and reopened it, with the "refresh on open" parameter checked, but they do not disappear. How do I get unused values to drop from the list? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - I can't delete unused values in selection drop-d
Jim,
Thanks so much for your prompt reply. I just tried the manual delete on your URL, and it worked on the old junk for stuff that was in the Row area, but not on the ones in the Column area, dunno why (I did them each separately, with a refresh). However, I then added in your macro and ran it, and it cleaned up ALL the old, in both worksheets. So I'm a bit curious if you have any feedback about why the manual method didn't work for the Columns. The only distinction I can see is that I have multiple Rows, but only a single Column (to select from, with multiple column output). Just trying to understand what's going on here, for the next time... In any case, you solved my problem, thank you so much! Linda "Jim Thomlinson" wrote: Check out this link... http://www.contextures.com/xlPivot04.html -- HTH... Jim Thomlinson "lireland" wrote: I have a pivot table by that I update every month, by refreshing the query to append the new data. It has data by customer and period, type of work, etc., with values for Parts, Labor, Tax, etc. I was asked to strip out data to leave only information to send to a single customer. I have removed all data from the source range except for that belonging to that customer, but in the pivot table selection box for customer, all of the other customers' names still appear. I have already resaved the entire pivot table and reopened it, with the "refresh on open" parameter checked, but they do not disappear. How do I get unused values to drop from the list? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Drop Downs | Excel Discussion (Misc queries) | |||
Pivot Table Drop Downs | Excel Discussion (Misc queries) | |||
Pivot table drop downs | Excel Discussion (Misc queries) | |||
Can Pivot table drop-downs act like AutoFilter | Excel Discussion (Misc queries) | |||
Data values WON'T DELETE in PivotTable drop-downs | Excel Discussion (Misc queries) |