Pivot table - old items

G

Goodlighting

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)
 
S

Shane Devenshire

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table blank rows 1
Pivot table wizards 2
date filter in a pivot table 1
Pivot table field. 2
Pivot Table: Cannot group that selection 1
Pivot Table - retains dates that are not in the source data 3
Grouping dates in pivot table 3
VLOOKUP Dates in a Pivot Table 1

Top