Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • 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.

Sean
0
Seancsn
Asked:
Seancsn
3 Solutions
 
Rgonzo1971Commented:
0
 
SteveCommented:
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.
0
 
terencinoCommented:
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

...Terry
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
redmondbCommented:
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?

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

Featured Post

Get your problem seen by more experts

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

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