Dependent Data Validation List - Displaying Only Partial List

Hi Guys,

I have 5 dependent drop-down lists, and all of them seem to be working fine except for the last one.
Each is dependent on the ones before, so by the time you get to the 5th one it is dependent on 1-4.
However, I'm noticing that for some reason the drop-down lists stop at 14 entries to select from, even though on my indexed sheet it is showing 34 entries for the last list.

Does anyone know how to correct this so that all 34 entries show up in the drop-down list properly.

I'm using version 2007.

Regards,

-Bob

Can you post some sample data?

It will take me some time to do this. I will need to re-create a whole new file as I can't post the data I'm working with.