Data validation problem

Copper Contributor

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."

3 Replies


Maybe this information can help you...

Excel Data Validation Examples

See the file "Data Validation Exambles.xlsx"



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.



I know I don't know anything (Socrates)



This doesn't solve the OP's answer. I have the same one btw.


Depends on where do you keep your file. For OneDrive or SharePoint it shall work.