What does the formula for AllParts (refers to ) look like. Are you using
relative references? they should be absolute.


Refersto: =Normal1!$A$1:$A$47

--
Regards,
Tom Ogilvy


Otto Moehrbach wrote in message
...
Excel 2003, WinXP
I have one list (column), named AllParts, with 47 items on sheet Normal1.
I do a Data Validation in a cell in sheet Normal1 with List and
"=AllParts".
I get the whole list.

I do Data Validation, the same, in a cell in sheet Normal2. I get the
whole
list

I do it all again in a cell in the sheet where I want it, call it
BadSheet,
and all I get is the first 14 items from the list.

I reset the range name AllParts to another, completely different list.

I go to the cell in BadSheet, clear the Data Validation, redo the Data
Validation to =AllParts. I get the same 14 items from the first AllParts
list.

Is this sheet corrupted or have I lost it? Thanks for your help. Otto