• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

2010 data validation not present in 03 and 07 excel versions

I have created a spreadsheet for customers with a summary sheet and a dedicated sheet for each customer. The last sheet has all the data vaildation lists. I have named each list and linked the name in each relevant cell on the customer sheets eg. =Practice.

Customers are still telling me that no drop down lists are appearing. they are using a mix of 97-03 and 2007 excel versions.

Any help much appreciated.

3 Solutions
You cannot have the list on another sheet in previous versions of Excel.

If you move the validation list to the same sheet, or hard code it, the list should work.
Can you send a screenshot of the data validation dialog? Some of the earlier versions of Excel had issues with off-sheet validation ranges, and rgonzo has a good point. Microsoft issued an instruction to help with that.

Using a validation list in another worksheet or workbook

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Hi, Seancsn.

Excel 2010 introduced a new Data Validation attribute ("<x14:dataValidations>") which doesn't play nicely with earlier versions of Excel. In my experience so far, using Names has sorted out this issue, but obviously not in your case.

Assuming that the data in the file is sensitive, could you please post a redacted copy here - a single customer sheet and the summary sheet with a single list is fine - as long as the file is showing the same problem.

BTW, is it possible that the Data Validations didn't originally use Names?

SeancsnAuthor Commented:
Thanks everyone. For some reason the Names set up is now working on the systems.
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now