| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
make Pivot table show only available values in dropdowns
Hello all.
I have a major pivottable (20+ fields, 30000+ records). this makes the dropdown menus very hard to operate (due to the hugh amount of values). Is there any way to make the dropdowns show only available values left after the previous filtering? I've noticed auto-filter does that automatically, but I cant find a way to do that in the pivot. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| how do I make hard carriage return appear in pivot table? | Excel Discussion (Misc queries) | |||
| Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
| show only > 9 in a pivot table | Excel Worksheet Functions | |||
Threaded Mode
