I still use Excel 97 at work....

I have a 100-row list, and I depend on autocomplete for easy data entry in row 101 and subsequently 102, 103 etc.

Why will Excel not autocomplete with the values near the top of my list?

Is there a row limit on autocomplete?