If I try to save as an older format it seems to lose the dropdowns.

I found this tutorial on a web site that has a tutorial on creating dropdown lists that is different than the 2003 way to do it. I don't have an older copy of Excel handy to try it now but can do so later. If someone tries this let me know if it works.

Drop Down Lists in Excel

-al