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
|