I am working in Excel 365 and have created some List Drop Downs using Data Validation. This spreadsheet is for someone who has an older version of Excel and when they open the file it removes all the Drop Downs. Is there a way to fix this?
Yes, earlier versions of Excel do not allow references to other sheets in a data validation list expression. The workaround is to create a named range on the other sheet then use that in the data validation expression.