Forum Discussion
Drop down lists from separate workbook
I'm trying to create a drop down list where the source data is in a separate workbook but can't seem to find anything in data validation that allows me to use a different workbook as a source. Any id...
Hi CJ_C42
as far as I know it's not possible to create dropdowns with an external workbook as a source.
And even if it was be possible, I would highly recommend not to do such things. References to external workbooks almost always create trouble, sooner or later.