Data Validation Drop Down List not Saving

%3CLINGO-SUB%20id%3D%22lingo-sub-1859067%22%20slang%3D%22en-US%22%3EData%20Validation%20Drop%20Down%20List%20not%20Saving%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1859067%22%20slang%3D%22en-US%22%3E%3CP%3EI%20create%20a%20Data%20Validation%20Drop%20Down%20list%20in%20Excel%2C%20and%20it%20works%20while%20I%20have%20the%20workbook%20open%2C%20but%20if%20I%20save%20and%20close%20the%20Excel%2097-2003%20Worksheet%20file%2C%20then%20re-open%20the%20file%2C%20it%20does%20not%20work.%20When%20I%20click%20the%20down%20arrow%20nothing%20happens.%20It%20is%20like%20it%20does%20not%20save%20the%20connection%20to%20the%20table.%20Anyone%20know%20why%20this%20is%20happening%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1859067%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1860198%22%20slang%3D%22de-DE%22%3ESubject%3A%20Data%20Validation%20Drop%20Down%20List%20not%20Saving%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1860198%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F859410%22%20target%3D%22_blank%22%3E%40G_Kealey%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20your%20text%20I%20cannot%20infer%20which%20version%20of%20Excel%20you%20are%20dealing%20with%2C%20knowing%20the%20operating%20system%20would%20also%20be%20a%20plus%20for%20a%20proposed%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ENevertheless%2C%20here%20...%20some%20information%20about%20it.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E-%20First%20define%20a%20name%20for%20the%20area%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E-%20and%20then%20use%20this%20name%20as%20the%20scope%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E-%20and%20then%20use%20this%20name%20in%20source%20%2F%20refers%20to%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3Edrop-down%20menu%20not%20visible%3C%2FSTRONG%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Flync%2Fen-US%2F0ca479fb-ebda-4fea-a2cf-1e9e8cd8c811%2Fexcel-2013-dropdown-menu-not-visible-in-excel-2007%3Fforum%3Dexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Flync%2Fen-US%2F0ca479fb-ebda-4fea-a2cf-1e9e8cd8c811%2Fexcel-2013-dropdown-menu-not-visible-in-excel-2007%3Fforum%3Dexcel%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I create a Data Validation Drop Down list in Excel, and it works while I have the workbook open, but if I save and close the Excel 97-2003 Worksheet file, then re-open the file, it does not work. When I click the down arrow nothing happens. It is like it does not save the connection to the table. Anyone know why this is happening?

2 Replies

@G_Kealey 

 

From your text I cannot infer which version of Excel you are dealing with, knowing the operating system would also be a plus for a proposed solution.

 

Nevertheless, here ... some information about it.

 

- First define a name for the area

- and then use this name as the scope

- and then use this name in source / refers to

 

drop-down menu not visible

https://social.technet.microsoft.com/Forums/lync/en-US/0ca479fb-ebda-4fea-a2cf-1e9e8cd8c811/excel-20...

 

 

Thank you for your understanding and patience

 

Hope I was able to help you.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here

 

@G_Kealey 

Most probably compatibility issues. As I remember in 97-2003 data for data validation list can't be in another sheet, perhaps something else. It works as it is now at least from 2010.