Forum Discussion
Solved
Why do dropdown lists appear differently on different computers and can it be changed?
Hi! I've created a dropdown list and the table that it references has 500 rows but only the first 20 rows are filled. On my computer, running Excel 365 and Windows 10, when I click on the dro...
If data validation list is based on the structured table located in the same sheet of the workbook, it expanded automatically with expanding of the table.
If table is on another sheet of same workbook, that doesn't work. As workaround for the drop-down list you may use formula like
=OFFSET(Sheet2!$A$2,0,0, COUNTA(Sheet2!$A$2:$A$500) )instead of the direct reference
=Sheet2!$A$2:$A$500
It sounds like the source for the data validation list is another workbook.
- Hi! Thank you! 🙂
Both worksheets are in the same workbook.
I laid out further what my workbook is like in my response to Riny_van_Eekelen and what I'm trying to accomplish. Thank you so much! Any ideas/suggestions/etc. that you have are greatly appreciated!
