Avatar of Patricia Timm
Patricia Timm
Flag for United States of America

asked on 

the drop down box on a column does not reflect my changes that I did in the source column

Have a column with a drop down table. The drop down when I look at data validation and the source shows a range in another sheets column(I will call column B. The range in column B is hard coded. When I update the hard coded name in Column B I should see the updated name in the drop down. The drop down is definetly populated by column B but I dont understand why when updating column B the changes are not reflected in the drop down??? Any ideas???
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Patricia Timm

8/22/2022 - Mon