sort order of pivot table drill down
 

Hello,

One of our users puzzled me again. :)

Excel 2003, query to a DB2 database.

User made a pivot table which uses this query as its data source.
When opening the drill down of a certain cell (left double click), a
new sheet is created.
The new sheet has no formatting and no (apparent) sort order.

His question: how to automagically set the sort order for the
drilldown?
According to some sources, this is determined by the sort order of the
source data. So that would be fixed with an "ORDER BY" in the query.
But other sources contradict this.

Any ideas?

--
Amedee