Add List of values in VBCS excel using data in another sheet

Summary:

Add List of values in VBCS excel using data in another sheet

Content (please ensure you mask any confidential information):

I have created VBCS excel to create Requisitions. We have around 50K active items, i want to provide an LOV for the item number field. I can create a Local data Source, but i am not sure of records limit. Instead, i want to provide 50K items in another sheet in the same excel, then i want to add that as LOV for item number. I can do it with excel functions, but it will be cleared when i clear the record. Please advise whether its possible to do it and any suggestions