The list functionality was introduced in xl2003, so it can not be reproduced
in earlier verions.

You will have to apply autofilters individually and sort individually
without the aid of special dropdowns.

--
Rgards,
Tom Ogilvy


"EDSTAFF" wrote in message
...
I have Excel 2003 at home, Excel 2000 at work. I created drop-down sorting
buttons at home using Data/List/Create List with range C11:J52. Text in
C11:J11 converted to headers for sorting. I was a bit dismayed when I
opened
file at work and sorting buttons/headers did not maintain sorting
function.
Is there a way to create Lists in 2003 and open in 2000 and maintaing the
sorting function created using Data/List? If not, how can I create the
same
funciton in 2000 at the office without using VBS (VBS not allowed at work
per
company policy)? Is there a control in 2000 that I am missing for this
function?

TIA