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
Hi Sergei!
Thank you so much!
I just saw this message from you, I apologize for my delay in responding.
My goal is to have it work for as many versions of Excel as possible even though I'm using 365 to create it.
That being said, is there anything I should be concerned about for folks using 365 if I use OFFSET instead of TOCOL or FILTER? You mentioned a better performance from TOCOL and/or FILTER for 365, does that mean that OFFSET might occasionally not work properly in 365?
Thank you again so much! Have a great weekend!
Diane
Thank you so much!
I just saw this message from you, I apologize for my delay in responding.
My goal is to have it work for as many versions of Excel as possible even though I'm using 365 to create it.
That being said, is there anything I should be concerned about for folks using 365 if I use OFFSET instead of TOCOL or FILTER? You mentioned a better performance from TOCOL and/or FILTER for 365, does that mean that OFFSET might occasionally not work properly in 365?
Thank you again so much! Have a great weekend!
Diane
I guess all works in 365.
But if many items available for pick,the Offset function will lead to run some slowly or response lag compared with FILTER in 365.
If too many items ,you many need database for quick serach.
But if many items available for pick,the Offset function will lead to run some slowly or response lag compared with FILTER in 365.
If too many items ,you many need database for quick serach.