Data Validation - Lists
is there a limitation on how many rows of data can have in a list?
I reference worksheet that contains the data for the reference list.
has 54 rows of names.
but on the worksheets that use the pick list it only scrolls down to row 52,
the last two names don't show up.

Help....