This doesn't work and I can't figure out why. Does the source table for valid data need to be on the same sheet or workbook? Mine is in the same workbook, but on a different sheet. Table is named...followed the steps and nothing is updated or dynamic. The source table is updated but not the validation drop down list.