Nothing you can do for it AFAIK

The DV list is in the cell. When you do a sort, cells are not moved, just the
data moves.


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 12:07:00 -0800, Jasonw151
wrote:

I have a list of data with multiple columns and one field has a list created
using the validation function. If a resort the document, it seems like the
list logic stays right where it was created. Is this a known problem or do I
possibly have something set incorrectly?