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.
Bookmarks