Working off of two sheets 1 is the chart with all of the assets, 2 is the data validation. I am able to use the drop down list as I would like in the very top cell but the rest of the 1800+ cells below that are not reacting correctly. Any ideas are welcome! A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

Anonymous 2023-02-24T17:11:20+00:00 Hi Michael, Greetings! Thank you for posting to Microsoft Community. Could you share us a file with some dummy data to test your drop down boxes? Best Regards, SnowLu 0 comments No comments Report Greetings! Thank you for posting to Microsoft Community. Could you share us a file with some dummy data to test your drop down boxes?