You'd only be able to put a small portion of the items into a custom
list. If they're text items, they should sort automatically when you add
them to the pivot table. If they're formatted dates, you could add a
column to the source table, and covert them to text, e.g.:

=TEXT(A2,"dd/hhmm")

However, if you use all day/hour/minute combinations, you'd exceed the
number of items allowed for a pivot field. There's information on the
limits he

Limits of PivotTables in Excel (Excel 97 - 2000)
http://support.microsoft.com/default.aspx?id=211517

Description of the limits of PivotTable reports in Excel (2002-2003)
http://support.microsoft.com/default.aspx?id=820742


RMF wrote:
I am having a similar issue. changing the order via dragging works, but
perhaps there is a easier way for me to order my pivot. I have a data sheet
with dates that are entered in the following format:

dd/hhmm, e.g. 12/0700

Is there a way of sorting this automatically in a pivot? If I would create a
list I would have to enter from 01/0001 until 31/2359 by entering 01/0001,
01/0002, 01/0003 and so on which is of course time consuming.

Is there a solution for this one?

Thnks!

"Matt Cromer" wrote:


Is there an easier way to use the Order function in Pivot Tables. Order,
Move Up/Move Down/Beginning...seems very awkward. The fields that I have
cannot be sorted ascending the traditional way, so I have to order them
manually. Are there any hot keys, or other ways to order??

Thanks!

Matt



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html