Pivot table field.
 

Hi - When I bring a new block of source data into a prelaid out pivot table,
I deleted say the Jan 09 data and bring in Feb 09 data but the drop down date
box on my date field continues to show 01/01/09, 01/02/09 etc when the only
dates available are now Feb dates...is there some way to get rid of the Jan
dates from the drop down box?
Thanks for any help.

Pivot table field.
 

http://www.contextures.com/xlPivot04.html
--
HTH...

Jim Thomlinson


"Jim W" wrote:

Hi - When I bring a new block of source data into a prelaid out pivot table,
I deleted say the Jan 09 data and bring in Feb 09 data but the drop down date
box on my date field continues to show 01/01/09, 01/02/09 etc when the only
dates available are now Feb dates...is there some way to get rid of the Jan
dates from the drop down box?
Thanks for any help.

Pivot table field.
 

Thanks a lot...the manual method works great.
Jim

"Jim W" wrote:

Hi - When I bring a new block of source data into a prelaid out pivot table,
I deleted say the Jan 09 data and bring in Feb 09 data but the drop down date
box on my date field continues to show 01/01/09, 01/02/09 etc when the only
dates available are now Feb dates...is there some way to get rid of the Jan
dates from the drop down box?
Thanks for any help.