Michael said:
I have cells with data validation based on a named range
with the same workbook. If I update the list, what must I
do to get the selected cells (drop-downs) updated with the
new text?
Thanks in advance.
When you want to add an item to your named range you must "stretch" the
referenced cell range. If you simply add a new item to the end of the
range, the size of the named range does not change, though surely it must in
order to contain the new item. To stretch the list, insert a cell somewhere
in the middle of the existing range, shifting the cells down if the range is
a column. Enter your new value in the new empty cell. Resort as desired.
To understand better what is happening, go to Insert>Name>Define. Find the
named range you are talking about, and note the cell range to which it
refers. Now cancel out of this. Then stretch the range as described above.
Now go back into Insert>Name>Define. You will notice that the cell range
has grown by the number of cells you inserted.
