Forum Discussion

Franz1901

Copper Contributor

Aug 25, 2020

Solved

Drop down list = statuslist

Dear all,

I just maintain an Excel Template and want to change values in a drop down list. Normally you can see the related values under source, but in source I founds the value =STATUSLIST. Where can I find that Statuslist to change values?

Thanks for any hint.

Best regards

Franz

wumolad
Aug 25, 2020
Franz1901

Go to formulas >> Name Manager to see the list of names and where the STATUSLIST is referenced in the workbook.

Cheers

3 Replies

wumolad
Iron Contributor
Aug 25, 2020
Franz1901

Go to formulas >> Name Manager to see the list of names and where the STATUSLIST is referenced in the workbook.

Cheers
- Franz1901
  Copper Contributor
  Aug 25, 2020
  wumolad got it, special thanks , stay healthy and have a nice day, cheers Franz from Germany
  - wumolad
    Iron Contributor
    Aug 25, 2020
    Franz1901
    
    Good to hear that. Stay safe too.
    
    Congratulations to Bayern Munich for winning the Champions League. Was painful when they beat my team Barcelona though.
    
    Cheers