Create numerous dropdown lists in Reference file to be opened/closed....continued

Is there a way to create a source list in excel that will be used only to create the drop down boxes in multiple copies of a similar profile on a network, so all drop down data can be updated only once! Via lists stored in source file?

I read the source file has to be open, but would there be a way to code a source file to be opened but not visible to use, so the data in drop down will be same on what is more than 200 files? Thx.