SOLVED

Drop down list = statuslist

%3CLINGO-SUB%20id%3D%22lingo-sub-1610544%22%20slang%3D%22de-DE%22%3EDrop%20down%20list%20%3D%20statuslist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610544%22%20slang%3D%22de-DE%22%3E%3CP%3EDear%20all%2C%3C%2FP%3E%3CP%3EI%20just%20maintain%20an%20Excel%20template%20and%20want%20to%20change%20values%20in%20a%20drop%20down%20list.%20Normally%20you%20can%20see%20the%20related%20values%20under%20source%2C%20but%20in%20source%20I%20founds%20the%20value%20%3DSTATUSLIST.%20Where%20can%20I%20find%20that%20statuslist%20to%20change%20values%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20hint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFranz%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1610553%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20list%20%3D%20statuslist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610553%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F770390%22%20target%3D%22_blank%22%3E%40Franz1901%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGo%20to%20formulas%20%26gt%3B%26gt%3B%20Name%20Manager%20to%20see%20the%20list%20of%20names%20and%20where%20the%20STATUSLIST%20is%20referenced%20in%20the%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22wumolad_0-1598363193931.png%22%20style%3D%22width%3A%20933px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214629i4A827D8FBB8B7F65%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22wumolad_0-1598363193931.png%22%20alt%3D%22wumolad_0-1598363193931.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1610564%22%20slang%3D%22de-DE%22%3ERe%3A%20Drop%20down%20list%20%3D%20statuslist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610564%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%20got%20it%2C%20special%20thanks%20%2C%20stay%20healthy%20and%20have%20a%20nice%20day%2C%20cheers%20Franz%20from%20Germany%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1610576%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20list%20%3D%20statuslist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610576%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F770390%22%20target%3D%22_blank%22%3E%40Franz1901%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20to%20hear%20that.%20Stay%20safe%20too.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECongratulations%20to%20Bayern%20Munich%20for%20winning%20the%20Champions%20League.%20Was%20painful%20when%20they%20beat%20my%20team%20Barcelona%20though.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

3 Replies
Best Response confirmed by Franz1901 (New Contributor)
Solution

@Franz1901 

 

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

 

wumolad_0-1598363193931.png

 

 

Cheers

@wumolad got it, special thanks , stay healthy and have a nice day, cheers Franz from Germany

@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