Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Filter
When I select a drop-down to a filter row (or column) to select a value I
often see or can select values that are no longer in the datasource. Is there a way to remove these simply. only way i can figure out is to rebuild pivot report or move the value to "page" and "hide items" but this is not very good or wise any ideas -- Kevin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Filter
There are instructions here for clearing old items from a pivot table:
http://www.contextures.com/xlPivot04.html Kevin wrote: When I select a drop-down to a filter row (or column) to select a value I often see or can select values that are no longer in the datasource. Is there a way to remove these simply. only way i can figure out is to rebuild pivot report or move the value to "page" and "hide items" but this is not very good or wise -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Filter
Thanks - is there any way to also i the field description box ie in the part
where you can "Hide Items" -- Kevin "Debra Dalgleish" wrote: There are instructions here for clearing old items from a pivot table: http://www.contextures.com/xlPivot04.html Kevin wrote: When I select a drop-down to a filter row (or column) to select a value I often see or can select values that are no longer in the datasource. Is there a way to remove these simply. only way i can figure out is to rebuild pivot report or move the value to "page" and "hide items" but this is not very good or wise -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Filter
I'm not sure what you mean. Can you give an example?
Kevin wrote: Thanks - is there any way to also i the field description box ie in the part where you can "Hide Items" -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Filter
when i double click on a field name, say in the column section it brings up a
box with info on the field. in older version of excel you can see all the values in this box and can manually select a value to hide it. I notice now however at home on my newer version of excel this is no longer an option. not to worry your first mail helps anyway -- Kevin "Debra Dalgleish" wrote: I'm not sure what you mean. Can you give an example? Kevin wrote: Thanks - is there any way to also i the field description box ie in the part where you can "Hide Items" -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Filter
Your newer version of Excel will still show that list if you
double-click on a page field button. In Page, Row and Column fields, you can show or hide items by checking or unchecking items in the dropdown list of items. Kevin wrote: when i double click on a field name, say in the column section it brings up a box with info on the field. in older version of excel you can see all the values in this box and can manually select a value to hide it. I notice now however at home on my newer version of excel this is no longer an option. not to worry your first mail helps anyway -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
Filter based on Pivot table | Excel Worksheet Functions | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |