ExcelBanter - AutoComplete not working after 4000 entries

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - AutoComplete not working after 4000 entries (https://www.excelbanter.com/excel-worksheet-functions/76170-autocomplete-not-working-after-4000-entries.html)

Phippsy

AutoComplete not working after 4000 entries

Autocomplete is picking up previous entries but once it gets beyond around
4000 entries it does not pick up the first 4000 entries. Is there somewhere
where this can be changed.
Thanks

All times are GMT +1. The time now is 05:26 AM.