All: I found an option that comes closer to the original intent of the
question.

Given a column of data named "ColumnX" in a table named "Table1", we have
all discovered that entering...

=Table1[[#Data],[ColumnX]]

.... in the "Source:" field of the Data Validation list dialog box will not
work.

However, the same syntax works for named ranges. For example, create a new
named range called "Test1" and enter...

=Table1[[#Data],[ColumnX]]

.... in the "Refers to" field.

Now in Data Validation, you can reference the named range "Test1" in the
"Source" field, using the syntax...

=Test1

It you add additional rows to "Table1", with new values in "ColumnX", the
data validation list is expanded accordingly. Also, sorting "ColumnX" in
"Table1" reorders the data validation list.

-------------

"DanL" wrote:

I have the same question, and no one has answered it yet. Can you use a
structured table reference instead of a named range in order to perform data
validation? In other words, instead of creating a table and having to
manually create a named range based on the table, can't I just use a formula
like =DeptSales[#Data] for a list data validation (where "DeptSales" is the
name of the table)? I get an error message when I try this...

"kr/nk" wrote:

Thanks to you, too.

This is still not the desired solution but based on your answers I guess I
cannot do what I exactly wanted to do but the old named ranges solution. It
was good if this cool new feature (I mean the structured references) worked
even with data validation.