Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Cleanup
Hello,
The pull down fields in my pivot tables have several values that are no longer valid for one reason or the other. They no longer appear in the source data of the table, in other words. Is there a way to clean up these pull downs to eliminate the unecessary data? Thanks, Tom |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Cleanup
Have you tried right-clicking on the pivot table and selecting Refresh?
"tommcbrny" wrote: Hello, The pull down fields in my pivot tables have several values that are no longer valid for one reason or the other. They no longer appear in the source data of the table, in other words. Is there a way to clean up these pull downs to eliminate the unecessary data? Thanks, Tom |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Cleanup
This refreshes the data showing in the table, but doesn't remove anything
from the pull down lists. Thank you for the reply though. "Duke Carey" wrote: Have you tried right-clicking on the pivot table and selecting Refresh? "tommcbrny" wrote: Hello, The pull down fields in my pivot tables have several values that are no longer valid for one reason or the other. They no longer appear in the source data of the table, in other words. Is there a way to clean up these pull downs to eliminate the unecessary data? Thanks, Tom |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Cleanup
Check out Debra's site for your answer:
http://www.contextures.com/xlPivot04.html -- Please remember to indicate when the post is answered so others can benefit from it later. "tommcbrny" wrote: This refreshes the data showing in the table, but doesn't remove anything from the pull down lists. Thank you for the reply though. "Duke Carey" wrote: Have you tried right-clicking on the pivot table and selecting Refresh? "tommcbrny" wrote: Hello, The pull down fields in my pivot tables have several values that are no longer valid for one reason or the other. They no longer appear in the source data of the table, in other words. Is there a way to clean up these pull downs to eliminate the unecessary data? Thanks, Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Can someone help Cleanup my recorded macro | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
recently used files, cleanup | Excel Discussion (Misc queries) | |||
Windows XP Disc Cleanup | New Users to Excel |