Drop-down menu problem

mycroft714

New Member
Joined
Oct 8, 2006
Messages
4
We have an excel file that we use to keep track of our DVDs. The first column is the DVD title, and we have a drop-down menu installed on it so we can easily jump from one dvd to the next. The problem is, it's stopped adding movies to the list, and we don't know why. Since this problem started, we've added about 200 new entries, and none of them appear on the dropdown menu. How can we fix this problem?

Thank you!
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,454
Hello mycroft714, welcome to the board.
What sort of 'dropdown menu' are you using?
Data Validation?, ComboBox? - or . . . (?)
I suspect it has to do with having reached your dropdown's input range about 200 rows ago.
 

mycroft714

New Member
Joined
Oct 8, 2006
Messages
4
The drop down menu is actually a filter that's sorting the column, that we've been using to easily jump around in the excel file. It cut off at adding data at a very random number, which is what through us off.
 

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,454
Are you filtering via some vba code, or is it being done manually?
(If you're using code, can you post it for us?)
It cut off at adding data at a very random number
Is it cutting off at the same number every time?
 

mycroft714

New Member
Joined
Oct 8, 2006
Messages
4

ADVERTISEMENT

Yes, it is cutting off at 1039.

I think we have hit the limit for the filter; I believe we've just been using autofilter.

I've started trying to see if creating a "list" through Data Validation will accomplish the same goal. One drawback so far is that it does not alphabetize the list of entries as the filter did.
 

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,454
I think we have hit the limit for the filter; I believe we've just been using autofilter.
I don't think this is the case here, at least not at 1,039.
I just filtered some random data and had it show me 28,414 (filtered) rows.

Is there possibly any difference in how the data is getting entered lately?
 

mycroft714

New Member
Joined
Oct 8, 2006
Messages
4
There's been no change in how the data's been entered.

I noticed something while I was playing around with the document: when I sort the file by a different column (say, year it was produced), then the drop-down filter list for the title column shows every single movie that's been input. But when I have the computer sort the file by the title of the movie, the dropdown filter list only shows the first 1095 entries (I mistyped earlier, it cuts off at 1095).
 

Forum statistics

Threads
1,136,926
Messages
5,678,606
Members
419,775
Latest member
joh93

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top