2010-2007 Data Validation Lists

Ok, I have experienced the data validation lists created in 2010 not displaying in 2007 issue. I have also found some information as to how to fix it; use named ranges.

Is there any other fix besides named ranges? I ask only because my data validation list is built off of dynamic data, therefore, I can't name the ranges.

Thanks.

EDIT: Ok, I tried saving the file as an Excel 97-2003 xls and that didn't work either. This is really dumb that Microsoft won't allow something like this.