| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum a pivot table field as a calulated field | Excel Discussion (Misc queries) | |||
| Pivot Table Field | Excel Discussion (Misc queries) | |||
| sum field is zero when using Pivot table | Excel Discussion (Misc queries) | |||
| Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
| How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Hybrid Mode
