Replying to myself:

The only way it can be done is creating a sheet in each workbook that looks at the list-of-values workbook.

Half elegant.

Still looking for a full elegant solution

Regards,

Ayal Telem.

Hi Ayal,

I'm not sure what you mean by 'plots', nor how your data is laid out. Can you please provide an example file that shows the data, and your desired result?

Mynda

Aside of a sample file I suggest you also mention the Excel version you're using

Hi Mynda and Hans,

1. Plots are agricultural sections or areas where you grow stuff.
2.  My Excel version is 365.
3.  I have attached 2 files: "Dusting Calc" & "Plots List - EN" (the 3rd file was loaded by mistake and I couldn't find how to delete it...).
4. In "Dusting Calc" file, column G in sheet "Dusting" takes its FILTER values from the sheet "Plots" in the same file.
5. I want to be able to take thouse values from the file "Plots List - EN" instead.

I hopen I was cleared this time.

Thanks for the efforts,

Ayal Telem.

Hi Ayal,

Thanks for clarifying. I don't recommend links to external workbooks. Instead, use Power Query to bring the Plots List data into the Dusting Calc file and reference it from there.

Most Excel formulas do not work when the workbook they are linked to is closed, so you'd have to open both files anyway. It's far more robust to simply connect to the Plots List with Power Query and set it to refresh on opening the file.

Mynda

Hi Mynda,

Thanks very much for clarifying this.

Regards.

Ayal Telem