Forum Discussion
Create a drop down list in Excel on Sharepoint
I keep trying to create a drop down list in Excel on Sharepoint by going to data validation, select list and then I select the data for the list in the 5 rows I created on another tab (just like you ...
ASourKraut Please mark this as resolved if it resolves your issue.
In Excel for the Web (SharePoint/OneDrive), data validation list ranges must be on the same sheet. The web version does not allow referencing ranges on other tabs — it just throws an error.
Solution
- Keep the list on the same sheet
- Move (or copy) your 5 rows of dropdown values to the same sheet where you want the dropdown.
You can hide these rows/columns later to keep things clean.
Thanks, but that doesn’t help. The process for doing this in the windows application needs to be the same as the web version. There is absolutely zero reason why there should be any difference between the two applications.