<div>
I'm not sure what are you trying to achieve. Do you want to use the list from Excel sheet without opening that sheet in Excel?
</div>


I'm not sure what are you trying to achieve. Do you want to use the list from Excel sheet without opening that sheet in Excel?

<div>
<div class="content wysiwyg-content">
I am familiar with creating a column filled with data to be used in a drop down list in excel.<br />
is there a way I can keep a constant data source without having to have an excel spreadsheet open.<br />
<br />
end goal is to have quick access in designing new spreadsheets to contain static drop down lists.
</div>
</div>


I am familiar with creating a column filled with data to be used in a drop down list in excel.
is there a way I can keep a constant data source without having to have an excel spreadsheet open.

end goal is to have quick access in designing new spreadsheets to contain static drop down lists.

Having constant connections to data sources in excel for drop down lists

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.