Forum Discussion
Excel Dependent Drop Down Lists not loading
Hello everyone. I created Dependent Drop Down Lists in Excel using the Offset Formula. When I open the sheet, the Drop Down Lists do not load but when I re-enter the same formula in Data Validati...
sid2109 What is the complete formula you're using in data validation? The described issue is most likely caused by creating an array reference directly within the formula (ie: range1&range2). Array references must be created in Name Manager.
For more information, please see: