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 ...
I am having the same issue, error code "The formula you entered is not valid.". I believe that is will work if I download and do it off line and upload but that is so much extra work (I have like 15 of these reports to do this with. trodgers
