Data validation problem

%3CLINGO-SUB%20id%3D%22lingo-sub-1710105%22%20slang%3D%22en-US%22%3EData%20validation%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1710105%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20Office%20365%20my%20student%20cannot%20create%20a%20dropdown%20menu%20using%20Data%20Validation.%20When%20choosing%20Settings%20%26gt%3B%20Allow%20%26gt%3B%20List%2C%20the%20Source%20field%20will%20not%20accept%20a%20range%20of%20values%20(for%20example%20%3D%24B%244%3A%24B%248).%20This%20entry%20gives%20an%20error%20message%20%22The%20formula%20you%20entered%20is%20not%20valid.%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1710105%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1710815%22%20slang%3D%22de-DE%22%3ESubject%3A%20Data%20validation%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1710815%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F808021%22%20target%3D%22_blank%22%3E%40trodgers%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EMaybe%20this%20information%20can%20help%20you...%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EExcel%20Data%20Validation%20Examples%3C%2FP%3E%3CP%3ESee%20the%20file%20%22Data%20Validation%20Exambles.xlsx%22%3C%2FP%3E%3CP%3ELink%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fapply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fapply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3EMicrosoft%20gives%20this%20info%20for%3A%3C%2FFONT%3E%20%3CFONT%20size%3D%223%22%3E%20%3CSPAN%20class%3D%22appliesToItem%20x-hidden-focus%22%3EExcel%20for%20Microsoft%20365%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%20for%20Microsoft%20365%20for%20Mac%3C%2FSPAN%3E%20Excel%20for%20the%20%3CSPAN%20class%3D%22appliesToItem%22%3Eweb%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202019%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202016%20Excel%202019%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3Efor%20Mac%3C%2FSPAN%3E%20Excel%20%3CSPAN%20class%3D%22appliesToItem%20x-hidden-focus%22%3E2013%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202010%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202007%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202016%20for%20Mac%3C%2FSPAN%3E%20Excel%20for%20Mac%20%3CSPAN%20class%3D%22appliesToItem%22%3E2011%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%20Starter%202010.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%20class%3D%22appliesToItem%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThank%20you%20for%20letting%20me%20offer%20you%20my%20help%2C%20I%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%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%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

In Office 365 my student cannot create a dropdown menu using Data Validation. When choosing Settings > Allow > List, the Source field will not accept a range of values (for example =$B$4:$B$8). This entry gives an error message "The formula you entered is not valid."

1 Reply
Highlighted

@trodgers 

Maybe this information can help you...

Excel Data Validation Examples

See the file "Data Validation Exambles.xlsx"

Link:

https://support.microsoft.com/en-gb/office/apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-ef...

 

Microsoft gives this info for: Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Starter 2010.

 

Thank you for letting me offer you my help, I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)