Pivot table manual AUTOSORT

[Aqua]

My worksheet contains a pivot table field ASOF MONTH dropdown list to get
data of monthly data
200101
.....
200805
200806

then i press REFRESH of pivot table to retrieve newest data (i.e 200807)

but the pivot table field still does not show the newest data in dropdown
list (ie. asof month 200807)
UNTIL
i press the dropdown list 'fields setting' -> 'advanced' ->'Autosort' ->
'ascending' or 'descending'.... instead its original setting 'manual'



i want to know why options 'manual' of AUTOSORT cannot refresh my ASOF MONTH
dropdown
list with newest data?
Any logic behind or i miss something?

Thanks all~

 

[Aqua]

Two things to check, which you've probably already covered...:

1) The target range that the pivot refers to covers the full range of
data? (I think you're OK here, just want to make sure)

no problem on preview

2) You are sure you are not missing the recent addition of the new ASOF
MONTH value to the pivot field? (I.e., before it is sorted correctly?)

Re: #2, is this a problem that repeats on every new addition of ASOF MONTH
value, or only just the first time you add new data?

this is just first time ...

thanks~