I have been working with a column of data where there are 6 different
people's names: (Alan, Chuck, Don, Frank, Rox and Vickie). The Autocomplete
option has been working nicely down the column. All the sudden, 192 cells
into it, a few of the words have stopped auto-completing. So, I have some
words (Frank, Alan and Rox) where Auto Complete is working fine and others
where I have to Type the full name in.

I have checked to make sure that the names are spelled correctly, so there
is nothing throwing off the autocomplete. I also reset the Autocomplete
on/off option. What can I do??