Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - old items
I have a pivot table set-up for tracking due dates and project information.
One of the fields I frequently use to sort is by the due date. After a due date has past I delete the date from the input table, however the date continues to show-up in the pull down menu of the pivot table field. Now I have to scroll through tons of old dates to access the valid ones. How can I get the field pull down list to update and remove any old dates that have been removed from the input sheet. (2003) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - old items
See Debra Dalgleish'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. "Goodlighting" wrote: I have a pivot table set-up for tracking due dates and project information. One of the fields I frequently use to sort is by the due date. After a due date has past I delete the date from the input table, however the date continues to show-up in the pull down menu of the pivot table field. Now I have to scroll through tons of old dates to access the valid ones. How can I get the field pull down list to update and remove any old dates that have been removed from the input sheet. (2003) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - old items
Hi,
Here's the intuitive? way - 1. Drag the field button for the Date field off the pivot table 2. Refresh the pivot table 3. Drag the field button for the Date field back on to the pivot table. Logical? If this was helpful, click the Yes button Cheers, Shane Devenshire "Goodlighting" wrote: I have a pivot table set-up for tracking due dates and project information. One of the fields I frequently use to sort is by the due date. After a due date has past I delete the date from the input table, however the date continues to show-up in the pull down menu of the pivot table field. Now I have to scroll through tons of old dates to access the valid ones. How can I get the field pull down list to update and remove any old dates that have been removed from the input sheet. (2003) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Items | Excel Discussion (Misc queries) | |||
count pivot table items | Excel Worksheet Functions | |||
Like items will not combine in a pivot table. | Excel Worksheet Functions | |||
Calculated Items in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table items | Excel Discussion (Misc queries) |