Power Query Connections and Data Validation

[AllisterB]

Hi
Currently I load queries to a sheet if I need to use some of the output of the query as a list in an Excel Data Validation. But I find this means I have more queries loaded than I would like.

Is there a way of using PQ output or connections as lists in Data Validation without having to load to the worksheet?

Thank You

Allister

[rorya]

No, there isn't. You can use a range or a hardcoded list of values, nothing else, sadly.