Forum Discussion
Drop-down list not updating from source list
I have a list of date which is the source for my validation, this list is an excel table, when I add a new data to this list the table automatically expand until this new cell, that's ok; nevertheles...
cataldotestani1990 , Data validation does not play nice with Table references. There are a couple of options to overcome this:
1) Named Range : Create a named range that references the Column - For example if your Table is named "Table1" and the column is "Values", create a Named Range called "DDList" that refers to "=Table1[Values]" and use DDList in the Data Validation
2) Use the INDIRECT function in the Data Validation dialog by typing in "=INDIRECT(
"Table1[Values]") in the dialog box when you select the list option.
See attached file with both options.