Forum Discussion
Data validation problem
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 ...
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.