Data Validation

%3CLINGO-SUB%20id%3D%22lingo-sub-1574783%22%20slang%3D%22en-US%22%3EData%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574783%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20drop%20down%20using%20Data%20Validation%20and%20need%20to%20know%20if%20there%20is%20a%20limit%20to%20the%20list%20items%3F%26nbsp%3B%20IF%20so%2C%26nbsp%3B%20is%20ther%20a%20work%20around%3F%26nbsp%3B%20I%20need%20to%20have%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1574783%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574805%22%20slang%3D%22de-DE%22%3ESubject%3A%20Data%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574805%22%20slang%3D%22de-DE%22%3EData%20review%20list%20limited%3F%20%3CBR%20%2F%3E%20As%20of%20Excel%202007%2C%20this%20limit%20has%20been%20increased%20and%20is%20now%2032%2C767%20characters%20per%20cell.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20*Theoretically%2C%20if%20you%20also%20save%20old%20files%20before%20Excel%202007%20with%20%22Save%20As%22%20under%20a%20new%20file%20name%20and%20select%20%22Excel%20workbook%20(*%20.xlsx)%22%20as%20the%20format%2C%20this%20should%20also%20expand%20to%2032%2C767%20.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%20*%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%20%3CBR%20%2F%3E%20*%20Beware%20of%20scammers%20posting%20fake%20support%20numbers%20here.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574817%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574817%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F753460%22%20target%3D%22_blank%22%3E%40KarenMarksKECM6619%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20mean%20text%20length%20for%20the%20items%2C%20when%20254%20characters.%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcelribbon.tips.net%2FT013164_Dealing_with_Text_Length_Limits_and_AutoFilter_Drop-Down_Lists.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcelribbon.tips.net%2FT013164_Dealing_with_Text_Length_Limits_and_AutoFilter_Drop-Down_Lists.html%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fwhat-is-limit-of-the-number-of-entries-in-excel%2F9ce4a909-8b03-428f-94a4-1b13433aa399%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fwhat-is-limit-of-the-number-of-entries-in-excel%2F9ce4a909-8b03-428f-94a4-1b13433aa399%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574825%22%20slang%3D%22de-DE%22%3ERe%3A%20Data%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574825%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3ECorrectly%20observed%20%3A-).%20%3CBR%20%2F%3E%20Not%20the%20Excel%20cell%20is%20limited%2C%20only%20the%20input%20field%20for%20the%20list.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3ESolution%3A%20%3CBR%20%2F%3E%20You%20write%20the%20list%20one%20below%20the%20other%20in%20a%20free%20%3CBR%20%2F%3E%20area%2C%20e.g.%20in%20from%20J28%20down%20to%20J38.%20%3CBR%20%2F%3E%20Without%20a%20comma.%20%3CBR%20%2F%3E%20In%20the%20data%20validity%20you%20then%20state%20as%20%22source%22%20%3CBR%20%2F%3E%20%3D%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%20.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EThx%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3ENikolino%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I created a drop down using Data Validation and need to know if there is a limit to the list items?  IF so,  is ther a work around?  I need to have 

3 Replies
Data review list limited?
As of Excel 2007, this limit has been increased and is now 32,767 characters per cell.

*Theoretically, if you also save old files before Excel 2007 with "Save As" under a new file name and select "Excel workbook (* .xlsx)" as the format, this should also expand to 32,767 .

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.
* Beware of scammers posting fake support numbers here.

@Sergei Baklan 

 

Correctly observed  :-).
Not the Excel cell is limited, only the input field for the list.

 

Solution:
Solution:
You write the list one below the other in a free area, e.g. in from J28 down to J38.
Without a comma.
In the data validity you then state as "source"
= $ J $ 28: $ J $ 38

 

Thx

Nikolino