Pivottable Drilldown Lists in wrong order (Excel, Pivottable)  
Author Message
tkrasinger





PostPosted: Visual Basic for Applications (VBA), Pivottable Drilldown Lists in wrong order (Excel, Pivottable) Top

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.hide-link.com/

Plz Help!



Microsoft ISV Community Center Forums3  
 
 
tkrasinger





PostPosted: Visual Basic for Applications (VBA), Pivottable Drilldown Lists in wrong order (Excel, Pivottable) Top

up
 
 
tkrasinger





PostPosted: Visual Basic for Applications (VBA), Pivottable Drilldown Lists in wrong order (Excel, Pivottable) Top

up

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


 
 
ADG





PostPosted: Visual Basic for Applications (VBA), Pivottable Drilldown Lists in wrong order (Excel, Pivottable) Top

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"