Forum Discussion
data validation allowing invalid values (list, source list have blank cells)
I tried to do like this, but it's not auto updating the list.
it's also not accepting Table1 as the source for validation
But when I added a new line to the table, the table adjusted.
Also, the range itself is a SORT(UNIQUE()) range (it's based on another range
The Source box of the data validation dialog does not accept a table reference. Simply select the current range of the table.
Here is an example:
This is the data validation dialog:
After adding two rows to the table, the new items are displayed in the drop-down:
The source has automatically been expanded (I did not have to edit it myself):
Maybe it's because the table is in other sheet?
this is what I have as the source:
=DESCRIÇÕES!$A$2:$A$366
But this is the table range after I added one line, the table in fact adjusted the range but Excel 365 it's not adjusting the range. (also, looking in your interface, possibly it's some issue related to 365?
(For the moment, I am doing a workaround, adding "-" to all blank lines in the range. It's not the best solution but while we are trying to understand what is happening)Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?