Sep 24 2020 12:12 PM
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."
Sep 24 2020 02:41 PM
Maybe this information can help you...
Excel Data Validation Examples
See the file "Data Validation Exambles.xlsx"
Link:
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)
Aug 11 2023 03:17 PM
Aug 12 2023 05:46 AM
Depends on where do you keep your file. For OneDrive or SharePoint it shall work.