I am using a Pivottable with external data in my Excel Sheet.

On the sheet I included a Button to refresh the pivottable via pv.RefreshTable

As there might be some new data, also the values of the drilldown lists may change. So when I initally created the pivot, I had these employees: Mister A, Mister B, Mister D, Mister F.

By clicking on "Refresh" some new data comes in, including Data from Mister C and Mister E. So the original drilldown list has:

(Show all)
- Mister A
- Mister B
- Mister D
- Mister F

after Clicking Refresh, the drilldown lists just added the 2 new employees:

- Mister A
- Mister B
- Mister D
- Mister F
- Mister C
- Mister E

How do I get them in the correct order, after refreshing the data?

( In reallity of course the list contains about 120 people and if you search for someone which name starts with "A", you won't start searching at the end of the list)

http://www.krasinger.at/public/drilldown.gif

Plz Help!

tkrasinger wrote:

up

can someone at least state that this simply doesn't work?

Hi

Did you remember to go into the advanced settings on the field and change the sort order from manual to ascending? You can do this with VBA if required e.g.

ActiveSheet.PivotTables("PivotTable1").PivotFields("Date").AutoSort xlAscending _
, "Date"