Forum Discussion

Copper Contributor

Apr 08, 2024

Solved

Excel - usage of drop-down list

Hello, I need some help regarding usage of drop-down list. I have several excel sheets, each sheet put into specific folders on a server. The first one is the main excel sheet where resides the fu...

excel

Formulas and Functions

JKPieterse
Apr 09, 2024
Nico_Kum It is likely your channel hasn't received that Validation update yet. It has been released to Monthly channel, but chances are you are on (semi) annual and have to wait some more months before it arrives.

JKPieterse

Silver Contributor

Apr 08, 2024

If you expect your AAA, BBB and CCC lists to grow, make sure your ORIGINAL lists are formatted as table (three separate tables!). That way, the range names AAA, BBB and CCC will automatically extend when you add data to each table.
In my Excel if I enter 01, it autocompletes to the full text 01_###_###_ABC. All I then have to do is press Tab or Enter to enter it into the cell.

Nico_Kum
Copper Contributor
Apr 09, 2024
JKPieterse

Hello Jan Karel,
Thank you for your prompt reply and yes, I forgot the tables.. many thanks.
But I tested again inserting the '01' instead of using the button list and I still receive the same error.
I checked my Excel version, I'm on a Win10 Enterprise with Microsoft 365 MSO ver. 2308.
I will do some more tests but if you have some good advice, I'm always interested.
Many thanks,
Have a nice day
Nicolas
- JKPieterse
  Silver Contributor
  Apr 09, 2024
  Nico_Kum It is likely your channel hasn't received that Validation update yet. It has been released to Monthly channel, but chances are you are on (semi) annual and have to wait some more months before it arrives.
  - Nico_Kum
    Copper Contributor
    Apr 09, 2024
    JKPieterse
    Thank you for the update, yes, all updates into my organisation is managed by the IT Team, I do not have any rights or access to.
    I will keep an eye on it.
    Thank you again,
    Have a nice day
    Nicolas